Keep in mind that your "helper column" can be a hidden column also.

"Michael" wrote:

You have to duplicate the names, addresses for each row that has a different
work experience per person, or include a helper ID column for each person.
--
Sincerely, Michael Colvin


"sort trouble" wrote:

I have seperate lists including first name, last name, address, and the a
final list for work expierence where i have the jobs for each person listed
below in seperate cells. I need to be able to sort by first, last, ect. and
have all of the cells from work expierence stay with the name and not just
the top cell. thanks