View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Johnny1496 Johnny1496 is offline
external usenet poster
 
Posts: 4
Default Data Consolidation

I have a large list (2000 entries) which contains about 60 different
categories. Right now, I have it listed like this:

Category A - Value 1
Category A - Value 2
Category A - Value 3
Category B - Value 1
.... etc.

Is there a nice way to consolidate this so that I have:

Category A - Sum of all A Values
Category B - Sum of all B Values
...etc?