Forum Discussion

Copper Contributor

Aug 15, 2022

Solved

Multiple IDs in a relationship

Hello, I have a lot of data in Excel and need to create some relationships between the two, however it's not that straight forward; Table 1 List of roles 1 role to many names and skills. (...

excel

JKPieterse
Aug 15, 2022
chrisingham Does this get you anywhere? I used PowerQuery to generate the green table.
RolesAndPeople.xlsx142 KB

JKPieterse

Silver Contributor

Aug 15, 2022

chrisingham Does this get you anywhere? I used PowerQuery to generate the green table.

RolesAndPeople.xlsx142 KB

chrisingham
Copper Contributor
Aug 15, 2022
JKPieterseYes, that perfectly fixes my problem! Thank you for this, saved me a lot of effort 🙂