Report formatting problem

[super_doodie]

I have the following data in an external file:

Dept Salesperson Sales$
---- ----------- ------
Auto John Doe 1000
Auto Jane Doe 1000
Auto David Smith 1000
Sports Mike Brown 1000
Sports Bob Smith 1000

I would like to format it in Excel so that it appears as follows:

Auto
John Doe 1000
Jane Doe 1000
David Smith 1000
Sports
Mike Brown 1000
Bob Smith 1000

Is there a way to do this? Thank you.

 

[Roger Govier]

Hi

Try using a Pivot Table to summarise your data.
Take a look here for help on getting started.
http://peltiertech.com/Excel/Pivots/pivotstart.htm

Regards

Roger Govier