Building dependency matrix RRS feed

  • Question

  • Hi Experts
    I have the following 2 tables:
    Table 1 has unique values and the team the defect is sitting currently on:

    Table 2 is the dependency chart which shows for ID to be fixed the "Depends on" column of defects need to be worked on first

    I would like for the output to look something like this that identifies the dependencies based on Table 1 and Table 2:

    Is this possible to do with either Power query or Pivot tables?


    • Edited by SamNaik Thursday, August 29, 2019 11:11 PM
    Thursday, August 29, 2019 11:08 PM