Sorting problem

[Guest]

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

 

[Guest]

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.

 

[Guest]

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