| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose Multiple Rows to one
Hello,
I'm trying to change the format of my data. Ex: apple 2 ab cd orange 5 ef gh banana 4 cd ef And I want to get it to the format: apple 2 ab cd orange 5 ef gh banana 4 cd ef Is there an easy way to do that? I can't figure it out with transpose or the offset function. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transpose multiple Columns to rows | Excel Worksheet Functions | |||
| how to transpose multiple rows into one column with row labeling? | Excel Discussion (Misc queries) | |||
| transpose multiple rows into one column | 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) | |||
Threaded Mode
