View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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?