Create multiple lists based on main data source

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

Here is a quick example, if a more in depth one is necessary I can post it later, but I will need to scrub out any confidential info.

Basically sheet 1 is what I have, a list of employees and the job they are on for the week, and sheet 2 is how we need to display them, the job on top and then the names of those working the specified jobs.

Thanks for the quick reply
7DAYEXAMPLE.xlsx

try

Please Login or Register  to view this content.

Awesome, thanks so much for the assistance! Sorry for the delay, managed to get some time away from my computer

Dan