Re-arrange multiple rows into a single row

Hello,

I am trying to move multiple rows and copy them in just a single row; something like the following:

Input arrangement:

row1 20 30 40 50

row2 60 70 80 90

row3 100

and I would like to move row2 and row3 to the row1, like:

Output arrangement:

row1 20 30 40 50 60 70 80 90 100

My spreadsheet has more than 60K rows, so I am looking for a suitable way of doing it faster. Could you help me with it?

mikeTRON,

Sorry about it. I totally forgot to be more specific here.

I have a file with 60K+ rows which I need to arrange every 3 rows into a row, i.e.,

row1 1 2 3
row2 4 5 6
row3 7 8 9
row4 a b c
row5 d e f
row6 g h i
.....

After re-arranging them:

row1 2 3 4 5 6 7 8 9

row4 a b c d e f g h i
.....

It looks like easy but I do not know how to deal with it.

Thanks in advance...

If there are just 3 columns of data in your worksheet, as in your example above, insert the formula below into cell D1 and drag down. Then if you want you can used fixed width or space based delimination under 'text to columns' to separate characters from the resultant string into individual cells. This would require pasting (special) formula values over the formulas to prevent the formulas, rather than the formula results being delimited.

Formula:

=IF(INT((ROW(A1)-1)/3)=(ROW(A1)-1)/3=TRUE,CONCATENATE(A1&" "&B1&" "&C1&" "&A2&" "&B2&" "&C2&" "&A3&" "&B3&" "&C3),A1&" "&B1&" "&C1)

It would result in

1 2 3 123456789
4 5 6 456
7 8 9 789
a b c abcdefghi
d e f def
g h i ghi