I have a data dump, and I need to break apart the column every time a value
(*dept*) shows in the first column:

finance dept
bob... ssn id-no
other data
sally...
(list of 15 more names)
mfg dept
joe...
bill...
(list of 30 more names)
payroll dept
lucie...
(list of 4 more names)
more depts with names...

so i need to loop thru the first column, and have each *dept* in it's own
new column or worksheet so I can print out each dept and other column info.
i've had suggestions to use 'split', but I'm not using the split function -
I need to break out each group of depts.