TRANSFORM TABLE MANIPULATION

[takbb]

I think this is a duplicate of this…

Table Manipulation comparing

Good afternoon guys, how are you? I have a big challenge and I would really appreciate your help. I need to do a forecast study, it should be done as follows, I have 3 tabs, each tab has a date period and some are repeated. So I have the Forecast -3, the forecast -2 and the forecast which is the newest and most revised. I would like to gather the date information of all the files but if it repeats itself it considers it the newest. Example in forecast -3 I have the day 12/8/2023, resulting …