Power Query - Create a Matrix from a Table

Question

I am reasonably new to Power Query and I'm trying to figure out the most efficient way to perform the transformation shown in the attached screen grab.

Currently I am loading the source table in to Power Query and doing the following:

1. Load the Source Table into Power Query
2. Create a Master Query containing all the data from the source table
3. Create a second query called Parent Task 1 by referencing the Master Query and filtering for Parent Task = Parent Task 1
4. Create a third query called Parent Task 2 in the same manner as second query
5. Create a fourth query called Parent Task 3 in the same manner as second query
6. Create a fifth query containing only unique Parent Tasks
7. Merge queries 2 to 5 to create required format.

I'm really hoping there is a more efficient way to do this. Any suggestions?

Answer 1

Excel 365 with Power Query.
Pivot()
One step.
https://www.mediafire.com/file/ifhgdqwwahqgrgg/10_07_21b.xlsx/file
https://www.mediafire.com/file/ku0tpopf90ps1xk/10_07_21b.pdf/file

Answer 2

Power Query is no longer supported here on Q&A. Please post your question over on https://aka.ms/PQCommunity.

Answer 3

Exactly what I needed, thanks.