thanks for the help everyone,
rod.

"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