Use Pivot tables

Add Column headers
Select the entire range including headers
Open Pivot Table wizard

Add column 1 2 3 t the row lables
Add amount column to the values

Also refer some interesting tutorals at
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

If this post helps click Yes
--------------
Jacob Skaria


"rodchar" wrote:

hey all,

i have some data like so:

ga, aug, rep1, $10.00
ga, atl, rep2, $5.00
ga, aug, rep1, $7.50
ga, aug, rep3, $5.00

is there a way in excel to convert to report format like so:

ga
- aug
-- rep1 - $17.50
-- rep3 - $5.00
--- total - $22.50
- atl
-- rep2 - $5.00
--- total - $5.00

thanks,
rodchar