I have 2 source data sets. lets say one has 1000 records which is a list of people with an email address and a capability they are interested in shadowing.
The other has 500 records with those people email addresses and the capability they work in and are offering to be shadowed on.
I need them to be paired if the wanted capability matches the "seniors" capability on a 1 to 1 pairing. no duplicated seniors on output and no duplicated juniors on output. So far I am having an issue getting all of them paired up without duplicates. attached is dummy data screenshots for an idea of what id like, aswell as a screenshot of how I was currently doing it which works for very small data sets but not for larger ones.
Dummy data:
Current set up:
