Compile staggered data into a single row

**jboomer** · 11-13-2009, 02:26 PM

I have allot data that is in stagered rows and would like to put it al into one row. I have atached a sample of the data. please let me know, as i have thousdands of records like this and do not want to have to do it manualy.

**stanleydgromjr** · 11-13-2009, 02:33 PM

jboomer,

Please post another workbook, with the first sheet as your sheet Sheet5 with more examples of image, and say Sheet6 with the way you want the data from sheet Sheet5 to look like.

**Paul** · 11-13-2009, 02:33 PM

Hi JBoomer,

Along with this sample data, please provide the results you expect (want) to see. That would be helpful, as there appears to be multiple rows worth of data for a number of the fields, and we would not know how to combine that information the way you might want to see it.