Hello All,

I have been trying to find an answer for my problem, but I am not sure how to word it. Basically I have a master list of employees, and the jobs they are working. I am trying to take my master list of information, and have it create a list for the jobs and the names of who is working them.

eg.

Column A
Employee 1
Employee 2
Employee 3
Employee 4
Employee 5

Column B
Job Name 1
Job Name 1
Job Name 1
Job Name 2
Job Name 2

Would give me a list that looks like:

Column A
Job Name 1
Employee 1
Employee 2
Employee 3

Column B
Job Name 2
Employee 4
Employee 5

I appreciate any help with this, or with being pointed in the right direction.

Thanks
Dan