I'm using Excel 2003.

I have a 2 column list of chapter members' names in one column and their
schools inthe other. There are over 1800 entries.

I want to end up with a single column sorted by the schools, with the name
of the school in a row, followed below by the names of the graduates in
separate rows. then the next school, etc.

Like
Emery-Riddle University
Jones, Frank
Smith, Fred
Franklin University
Adams, Susan
Baker, Sam

Is there a formula that can do this or do I have some (a lot) manual
formatting to do?

Thanks,

Dennis