Hi,

You can use the Data, Subtotal command to do this, although I prefer the
Pivot Table.

Sort your data by column B. Then choose Data, Subtotal and choose column
B's title from the At each change in, Use function Sum and check the column
with your values.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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