| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to transpose multiple rows into one column with row labeling?
Dear all,
I need to convert the following table: a 1 2 3 b 7 8 c 4 5 6 9 into: a 1 a 2 a 3 b 7 b 8 c 4 c 5 c 6 c 9 how to do it? thanks, pemt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| transpose multiple rows into one column | 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
