S
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.
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.