Format 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?

Format and Possible Transpose
 

Daren

Why does a simple sort on the name column A not work?

Make sure you select all three columns before sorting on the name column.

If something else needed.........................

Post a small sample of what your data looks like now and what you want it to
look like.


Gord Dibben MS Excel MVP

On Tue, 17 Jul 2007 17:36:01 -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?

Format and Possible Transpose
 

Gord,
The data needs to go from this:

Ted, North, Couch (row 1)
Ted, South, Couch (row 2)

to

Ted Ted
North Couch
South Couch

The data set is quite large, so I'm just trying to find a way to make it go
faster.

Thanks for your help,
Daren

"Gord Dibben" wrote:

Daren

Why does a simple sort on the name column A not work?

Make sure you select all three columns before sorting on the name column.

If something else needed.........................

Post a small sample of what your data looks like now and what you want it to
look like.


Gord Dibben MS Excel MVP

On Tue, 17 Jul 2007 17:36:01 -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?