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.
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!