Table Organization for Staffing

Good Afternoon All!

This may have a simple solution that I am just not seeing, but I am on a bit of a time crunch to get this done for work. I work in a moderately sized facility and have been tasked with arranging a spreadsheet of our employees (~500) into groups based on their title. I have been given a spreadsheet with the following columns:

Last Name | First Name | Title

What I am looking to do is create a new sheet for each Title, and have a table on that sheet that will populate with all the names of each person who has that title. So for example, Sheet 1 will be the main source data, then Sheet 2 will have a table for the title of Nurses Aide, Sheet 3 will be for Nurses, and so on. I am currently trying to do so with a pivot table, which for the most part is functioning properly. The main issue I am encountering there is that we have some employees who share the same last name, i.e. "Williams" only appears on the table once, but there are 3 different employees who share that last name.

Image of what I have so far below:
cnatable.png

The only way I have come up with to solve that would be to merge the Last Name and First Name columns, but that would take far longer than I really have to do this.

Any suggestions or solutions are more than welcome, Thanks all!!

Originally Posted by MarvinP

Hi kblock and welcome to the forum

Thank you!

I appreciate your guys' help, I did try moving the Titles to the report filter which did help a bit but I was still have the trouble with the multiple first names filing under the same last name. So, I did the glaringly obvious and combined the First Name and Last Name columns into a third called Full Name by using the very simple (but alas, new to me!) { =A10&", "&B10 } formula. I then listed both the Title and Full Name into the "Row Labels" field. This actually allowed me to add a bit more functionality to the workbook as whole, so I've accomplished what I needed to and more! So many thanks to all!

Updated examples attached.

t1.png
t2.png