I have an excel sheet which i am sending in the attachment.
In sheet 1 I have this:
In Sheet 2:
What I want to make in Sheet 1 is:
Name Group Department
James A QE
Brian B Dev
Richard D Dev
Jake C Dev
Lora B QE
This is just an example and the actual list is so long.
How can I make it diagrammatically in Excel?