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

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

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

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