Multiple columns into single row
 

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

Multiple columns into single row
 

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



Mr. R wrote:

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

Multiple columns into single row
 

"Dave Peterson" wrote:

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



Mr. R wrote:

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
.
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.

Multiple columns into single row
 

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?



Mr. R wrote:

"Dave Peterson" wrote:

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



Mr. R wrote:

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
.
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