08-22-2020 01:43 PM
08-22-2020 02:26 PM
@SubhasisB here is an alternative way using offset. For simplicity, I am assuming that all of your Product lists under each date are the same.
That said, you probably could or should consider using a pivot table to get what you want.