if you had data in column A, B, C and D on both rows 1 and 2, then after
this was done, would row 1 have data in

A B C D E F G H where E would be row2, column A data, F would be
row2, column B data and so forth.

Also, is all data constants or are there formulas involved - if formulas, do
you want the data transferred as constants?

can we assume all the data is contiguous in a row or are the blank cells
embedded between filled cells - if so, do you want the blank cells skipped
or reproduce to maintain column alignment.

--
Regards,
Tom Ogilvy

"Yogi_Bear_79" wrote in message
...
I need to concatanate the odd rows to the ends of the even rows. Starting
at
row 2. I'd like the filled cells from row 2 to be added to the first empty
cell in row 1. I'd like this proces to continue to the end of the
spreadsheet.

Once completed I should have 1/2 the original rows