I have a table that is generated from a data source. The table is based on a 6-month time frame. My challenge is how to populate the table if I do not have all 6-months of available. So if I have 3-months of data, then they those 3-months would be displayed reading left-to-right, with the oldest in the left most column.
I have played with nested IF statements, but with no success.
Attached is a small example of my data with a table showing 4 of the 6 months and one with all 6-months. Table_With_Moving_Data_EE.xlsx