I got this table in the power query editor with items, their quantits and their processes.
I need to make it ready as a format like this:
It is like a relationship table. Process1 and process 2 and their quanties and then a combined query with process 2 and process3 and so on. They need to be in the Columns "From" and "To".
My go to now is to make a query for every relationship und then combine all the querys at the end. But i cant figure out a wway to make it all in one query.
I really hope you can help me :)