Consolidate and extract first data

[YXM1012]

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:

[Qiu · Accepted solution]

@YXM1012 

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