| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Transpose Arrays with variable row counts
I have a list that I need to transpose and can't figure out how to accomplish it. Spreadsheet looks like this:
Column A Column B AA Apple AA Pear BB Orange BB Pineapple BB Strawberry CC Orange and I want to transpose it to be: Column A Column B Column C Column D AA Apple Pear BB Orange Pineapple Strawberry CC Orange Can anyone help?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing Arrays | Excel Discussion (Misc queries) | |||
| make a vlookup using a variable path | Excel Worksheet Functions | |||
| I Need VBA Assistance for global variable question | Excel Discussion (Misc queries) | |||
| transpose a column into many rows | Excel Discussion (Misc queries) | |||
| TRANSPOSE() | Excel Worksheet Functions | |||
Threaded Mode
