Jul 20 2006, 02:44 AM
Does anyone know how i can go through a spreadsheet and take every even row and merge it to the row above (i.e take all of the data from row A2 and merge it at the end of the data in row A1)
Jul 20 2006, 03:54 AM
are all the data in the row numeric? If not, how do you want to aggregate the textual data?
Or, reading your post more closely, you need something like this automated?
= A1&A2, =B1&B2, =C1&C2
=A3&A4, =B3&B4, etc...
In the latter case, VBA approach would be most appropriate, probably. You'll need to loop through the rows with Step 2 and agreegate the data on a new sheet.