| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create single column from multiple columns. | Excel Discussion (Misc queries) | |||
| move multiple columns into single set of columns | Excel Discussion (Misc queries) | |||
| How do I convert multiple columns to a single column? | Excel Discussion (Misc queries) | |||
| Single column into multiple columns | Excel Discussion (Misc queries) | |||
| Multiple Columns to Single Columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
