I am pretty new to Power Query so please be gentle!
I have a table with 2 column's from a database. The first column is a Parent recipe, the second column is a Child recipe. Recipes will be found in both columns so no unique records.
Example:
PR CR
A B
C B
D C
E C
F E
G C
I need to create what is effectively a "recipe tree" table which can be put in a pivot table. Recipes can appear multiple times in each column as they are modified along the way to create a finished product. It may also go through a different number of processes along the way.
The aim is to identify which finished products the starting recipe is used in.
The result I think I need for the above is something like:
R1 R2 R3 R4
B A
B C D
B C E F
B C G
How could I go about doing something like this? I have tried searching but can't find the keywords to unlock something like this.
Thanks in advance
I have a table with 2 column's from a database. The first column is a Parent recipe, the second column is a Child recipe. Recipes will be found in both columns so no unique records.
Example:
PR CR
A B
C B
D C
E C
F E
G C
I need to create what is effectively a "recipe tree" table which can be put in a pivot table. Recipes can appear multiple times in each column as they are modified along the way to create a finished product. It may also go through a different number of processes along the way.
The aim is to identify which finished products the starting recipe is used in.
The result I think I need for the above is something like:
R1 R2 R3 R4
B A
B C D
B C E F
B C G
How could I go about doing something like this? I have tried searching but can't find the keywords to unlock something like this.
Thanks in advance