Consolidate and extract first data

Question

Hi community,

I appreciate your help with the following case:

I have a database like this:

I want to consolidate the information by product taking the first or most recent price and include the corresponding start and end date.

Output:

Example.xlsx

Qiu · Accepted Answer

@YXM1012

I use the start time to judge if it is latest or not.