Forum Discussion

chrisingham's avatar
chrisingham
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's avatar
    JKPieterse
    Aug 15, 2022

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

JKPieterse's avatar
JKPieterse
Silver Contributor
Aug 15, 2022

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

  • chrisingham's avatar
    chrisingham
    Copper Contributor
    Aug 15, 2022

    JKPieterseYes, that perfectly fixes my problem! Thank you for this, saved me a lot of effort 🙂 

Resources