Extract Recent Data

YXM1012

Hello everyone,

I appreciate your help with the following case:

1. I have historical data of price change for different products:

I would like to consolidate the data by product showing the current price "Base Price" and most recent "promo price" for each product)

Note: The base price doesn't have an end date.

Thanks in advance!

Example.xlsx

mbarone

Have you tried anything using the Filter tool, Summarize tool, and Crosstab tool?