Hello,

I'm trying to consolidate down a large list of data to just its header row and then the 2 following rows, into one large column. Any suggestions on how to do this?? I have included a simplified data set of what I'm trying to do. Thanks for all your help in advance!


excel link pic.jpg
Screen shot 2012-05-21 at 7.16.10 PM.png
Sample set.xlsx