Question

You import a sales worksheet into Power Query where each product occupies a single row, and there are four separate columns named Q1, Q2, Q3, and Q4 holding the quarterly revenue values. Your data model requires a normalized structure with one row per product per quarter, containing a 'Quarter' column and a 'Revenue' column. Which Power Query transformation should you apply to the four quarter columns?

Accepted Answer

Select the Q1–Q4 columns and choose Unpivot Columns

Answer

Select the Q1–Q4 columns and choose Pivot Column

Answer

Select the product column and choose Group By with a Sum aggregation

Answer

Select the Q1–Q4 columns and choose Merge Columns