Power Query - Create a Matrix from a Table

Martin Kerr 21 Reputation points
2021-10-07T12:36:31.443+00:00

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?

138499-screenshot-2021-10-07-at-132334.png

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,667 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,689 questions
0 comments No comments
{count} votes

2 additional answers

Sort by: Most helpful
  1. Ehren (MSFT) 1,781 Reputation points Microsoft Employee
    2021-10-07T20:51:47.817+00:00

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

    0 comments No comments

  2. Martin Kerr 21 Reputation points
    2021-10-08T09:03:25.623+00:00

    Exactly what I needed, thanks.

    0 comments No comments