Combining data sets with duplicate information (real tester!!)

peraphs to get a good specific solution you should provide more info about your data sets.

Some, but not all possible question about your datasets
How big is your data set?
The names have a predetermined order can they be associated with the first available id or is there some constraint?

Do the two tables have the same number of rows?

If the structure is the same as the examples shown, an immediate solution is to sort the two data sets primarily on the "role" fields and secondarily on the other field and then build a table with the two columns "name" and "id".