Multiple columns into single row

  • Thread starter Thread starter Mr. R
  • Start date Start date
M

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 said:
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.
Click to expand...

Thanks Dave.
 
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?
 
Back
Top