[Solved] Which of the following is the correct way to pivot columns in Power Query Editor? — Ans: Select columns, then choose 'Pivot Columns' from the Transform tab | Power BI

Power BI - Data Cleaning with Power Query

Which of the following is the correct way to pivot columns in Power Query Editor?

ASelect columns, then choose 'Pivot Columns' from the Transform tab

BSelect columns, then choose 'Unpivot Columns' from the Transform tab

CRight-click a column and select 'Add Column' to pivot

DUse the 'Group By' feature to pivot columns

Step-by-Step Solution

Solution:

Step 1: Recall Power Query pivot steps
To pivot columns, you select the column to pivot and use the 'Pivot Columns' option in the Transform tab.
Step 2: Eliminate incorrect options
'Unpivot Columns' does the opposite, 'Add Column' does not pivot, and 'Group By' aggregates but does not pivot.
Final Answer:
Select columns, then choose 'Pivot Columns' from the Transform tab -> Option A
Quick Check:
Pivot Columns button = correct pivot method [OK]

Quick Trick: Use 'Pivot Columns' in Transform tab to pivot [OK]

Common Mistakes:

Master "Data Cleaning with Power Query" in Power BI

9 interactive learning modes - each teaches the same concept differently

More Power BI Quizzes

Which of the following is the correct way to pivot columns in Power Query Editor?