Power Query help to extract unique values

So in this case, I am working with a roster list that changes weekly. I have posted a screenshot that shows a small example of what i am dealing with. We're talking literally 1000's of agents that I ...