| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
transpose multiple rows into one column
Dear all,
How to transpose the below table into one column (actually 2 columns) with name? my table: Name col1 col2 col3 col4 A 10 20 30 40 B 50 60 C 70 80 90 transpose into: Name col1 A 10 A 20 A 30 A 40 B 50 B 60 C 70 C 80 C 90 Thanks, pemt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transpose Column to Rows | Excel Discussion (Misc queries) | |||
| Transpose every 10 cells in single column to multiple rows | Excel Discussion (Misc queries) | |||
| transpose multiple rows at once | Excel Discussion (Misc queries) | |||
| Can you transpose 1 column into multiple rows creating a table | Excel Discussion (Misc queries) | |||
| transpose a column into many rows | Excel Discussion (Misc queries) | |||
Threaded Mode
