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?

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?