| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple ranges, transposing?
I start with a list like this
company carries 101 INDUSTRIES BRASS LIGHTING HOME NICKEL FRANKFURT BRASS FRANKFURT NICKEL FRANKFURT STAINLESS FRANKFURT COPPER Jersey COPPER Dallas NICKEL Dallas STAINLESS Dallas COPPER I need to end up with a list like this company carries 101 INDUSTRIES brass LIGHTING HOME NICKEL FRANKFURT BRASS NICKEL STAINLESS COPPER Jersey COPPER Dallas NICKEL STAINLESS COPPER If it were just these few, I would insert some blanks and then transpose. But my list is over 30,000 rows with a few thousand different companies. I'm pretty new with this level of Excel and am about to bang my head with frustration. Can someone help? Please!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transposing multiple columns to rows | Excel Worksheet Functions | |||
| Transposing One Column to Multiple Rows | Excel Worksheet Functions | |||
| Transposing Multiple Cell References to Multiple Values (NOT total | Excel Discussion (Misc queries) | |||
| Transposing Multiple Cell references as Multiple Values | Excel Discussion (Misc queries) | |||
| transposing data from 1 column into multiple rows | Excel Discussion (Misc queries) | |||
Threaded Mode
