Hi,

I have a question that I'm sure will have been asked before, but I
can't for the life of me find it by searching - all i find is
information on using Data Sort.

The problem is, after manipulating some personnel data, I'm left with
the following layout of information:

Column A
....
DEPARTMENT: Human Resources
Adam Brown
Cecil Davies
DEPARTMENT: Finance
Elliot Farthing
Gary Holmes
Ian Jacobs
DEPARTMENT: Human Resources
Kris Lambs
DEPARTMENT: Finance
Mark Namara
....

Column B is blank for the Department rows but contains personnel ID
numbers for the employee rows. What I want to do is sort/group this
information by department and their corresponding employee ID's. ie:
....
DEPARTMENT: Finance
Elliot Farthing 123
Gary Holmes 456
Ian Jacobs 789
Mark Namara 246
DEPARMENT: Human Resources
Adam Brown 810
Cecil Davies 121
Kris Lambs 416
....

Can anyone please tell me how to go about doing this?