Can anyone suggest a formula that would take the data presented below into a consolidate single line item with the data presenting in a horizontal time ordered way? I have tried using MATCH & INDEX & VLOOKUP but I am not an Excel guru and am not sure if its even possible.
00007502.............6/28/2010............Posted
00007502.............9/28/2010............Posting Expired
00007502.............10/19/2010...........Posted
00007502.............1/1/2011..............Posting Expired
00008765.............5/30/2010............Posted
00008765.............12/6/2010............Posting Expired
to
.........................Posted........................Posting Expired...........Posted........................Posting Expired
00007502............6/28/2010....................9/28/2010.................10/19/2010..................1/1/2011
00008765............5/30/2010....................12/6/2010
Bookmarks