Yes, use a pivot table. While using the pivot table wizard, layout the
classification in the row area, double-click "classification" and turn
subtotals off (so select "None"), click okay for that and then layout the
names in the row area. You should then see your list nicely laid out just
the way you hoped.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"alwein" wrote:

I have a file that contains, among other things, names and "classification"
(roughly equal to occupation ala Attorney, Accountant, etc.). I want to
create a list that shows names within classification ala Accountant then
Adams, Jones, Smith, then Attorney then Boswell, Harrison, etc. It seems
there should be a way to do this other than manually. Is there?
TIA,
--
Al the Computer Pal