Excel - Summarising Roles for a Roster

Hello,

I am creating a spreadsheet that will be used to assign rosters and keep track of staffing levels. I have finished most of it but have come up to a final hurdle. I want to be able to create a list of people doing individual roles. Initially I tried a VLOOKUP and this worked ok up until I had several people doing the same role. I also tried to use a pivot table but this only shows total numbers for each role.

Does anyone out there have any suggestions for what I should try? Your help would be much appreciated.

Thanks