Need help Finding a Formula to use

I have this data that I want to use. I want to create visulizations by division but as you can see two providers work at multiple locations. How can I make sure those people are routed to the c...