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


--
HBF
------------------------------------------------------------------------
HBF's Profile: http://www.excelforum.com/member.php...o&userid=34019
View this thread: http://www.excelforum.com/showthread...hreadid=552336