Multiple columns into single row

[Mr. R]

I have multiple columns :

1 2 3 4
1 2 3 4
1 2 3 4
....

And I want to paste into a single row:
1 2 3 4 1 2 3 4 1 2 3 4.....

Transpose does not do it. Any suggestions?

Thanks

 

[Dave Peterson]

Always 4 rows by 4 columns becoming 1 row by 16 columns?

 

[Mr. R]

Always 4 rows by 4 columns becoming 1 row by 16 columns?





--

Dave Peterson
.
In my particular case, I have 4 columns and say 20 rows in some cases and 4 cols and 'n' rows. Which ever the number of rows, I would like to have one row and 4 x n columns.

Thanks Dave.

 

[Dave Peterson]

How do you determine the number of rows per group?

Is there an empty row between groups?

Is there some key indicator on the first row of a group?