How to transpose a table in Power BI from Row to Column

Question

I am having trouble structuring my PowerBI data in the required format. I am attaching the data structure below.

My Data Structure:

enter image description here

Required Output Structure:

enter image description here

mkRabbani · Accepted Answer · 2020-10-25 15:42:39Z

1

Step-1: Go to Power Query Editor and right click on your ID column and select GROUP BY option and select other options as below-

Now you will get table per ID as shown below-

Step-2: Add a custom column as below-

Step-3: Extract values from the list column using comma separation as shown below-

Now you have records as below-

Step-4: Finally split the new column using Comma again and you will find the output as below-

Step-5: Remove the column AllRecords and rename new columns as per your requirement.

answered Oct 25, 2020 at 15:42

mkRabbani

16.9k2 gold badges17 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1