I have a spreadsheet which has name IDs as a list in Column A with Row 1 [from B onwards] used to show the dates.
Name IDs will have a unique letter code under certain dates.
How can I make a list to show all the names for each date with content.
What I am looking to achieve is this:
I have multiple years worth of sheets to combine and the name ID list is over 200 long!
Any help would be much appreciated, thank you in advance!