Sorting problem
 

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

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

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