Col A (starting with A2) contains data that randomly repeats itself:
A
B
D
A
B
C etc
Row 1 contains the Friday of the week starting on B1
6/2
6/9
6/16 etc
Where the rows and columns intersect is data
for instance: B2 contains "Test" because A is in Test on 6/2
C5 contains "Paint" because A is in paint on 6/9
I need to take this data and make it so it reads on one row
so for instance on row 1 & 2:
blank 6/2 6/9
A Test Paint
Is there a way to extract the information on one row? I tried using a vlookup with a match, but it only brings in the first value.
Thanks
Bookmarks