Combine 2 rows into 1 row, over and over

Closed
Brando - Mar 18, 2010 at 01:28 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 19, 2010 at 04:17 PM
I have over 5,000 rows of items I need combined, but they need to be combined in a certain way. Below is an example of the information I have, all in a single column. I need to combine the 1st 2 rows into a single row and the 3rd and 4th rows into a second row.

Here is what I have -

row 1 12 Individual Item
row 2 Item: DVD Complete Series (Hyb)
row 3 23 Individual Item
row 4 Item: DVD

Here is what I would like -

row 1 12 Individual Item Item: DVD Complete Series (Hyb)
row 2 23 Individual Item Item: DVD

I Figured it out. Thanks.
Related:

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 19, 2010 at 04:17 PM
It would have been nicer, had you also mentioned the solution so that if some one was looking for same thing down the road, your solution might have helped him too.
1