Pairing up people with conflicting data

Question

I am looking at using data to suggest 'buddies' within an org based on their knowledge. Ie. pairing people with poor skills in a topic with people who are awesome in a topic.

The data looks a bit like this:

PersonSkillSkill levelDerekExcelPoorPeterPublic speakingIntermediateSarahExcelAdvancedJudithAlteryxIntermediate

And in this example I would want to pair Derek with Sarah because he is poor and she is advanced. Judith and Peter have no matches:

PersonSkillSkill levelPersonSkillSkill levelDerekExcelPoorSarahExcelAdvanced

Any thoughts from the hive mind?

DKMI · Answer

Cute solution.

Thank you!

binu_acs · Answer

@DKMI One way of doing this

Transpose_012623.yxmd