| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting and Possible Transpose
I have three columns of data including, in order, name, region, product. For
example, Ted, North, Couch. The first row is the headear row containing the name, region, and the product, after which the data appears. Instead of each line containing individual names, regions, and products, I want to have the rows organized by name. A simple sort does not work. How can I solve this problem? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formatting and Possible Transpose
See response in the other group you multi-posted to.
Gord Dibben MS Excel MVP On Tue, 17 Jul 2007 17:36:02 -0700, Daren wrote: I have three columns of data including, in order, name, region, product. For example, Ted, North, Couch. The first row is the headear row containing the name, region, and the product, after which the data appears. Instead of each line containing individual names, regions, and products, I want to have the rows organized by name. A simple sort does not work. How can I solve this problem? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| transpose | Excel Discussion (Misc queries) | |||
| Transpose!! | Excel Discussion (Misc queries) | |||
| Transpose Color Formatting to Seperate Worksheet | Excel Worksheet Functions | |||
| I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions | |||
| TRANSPOSE() | Excel Worksheet Functions | |||
Hybrid Mode
