You use Power Query Editor to import and preview sales data from the years 2020 and 2021 in a Microsoft Excel file as shown in the following exhibit. You need to shape the query to display the followi

The correct answer is C. Unpivot columns. The source data is in a pivoted format where year columns (2020, 2021) are spread across the top, with months as rows. The target shape requires three columns: Month, Sales, and Year - meaning the year column headers must become row values. This is an unpivot operation (C): selec

Submitted by eva_at· Apr 18, 2026

Question

You use Power Query Editor to import and preview sales data from the years 2020 and 2021 in a Microsoft Excel file as shown in the following exhibit. You need to shape the query to display the following three columns:

Month
Sales
Year

What should you select in Power Query Editor?

Exhibit

Options

AMerge columns
BTranspose
CUnpivot columns
DPivot column

How the community answered

(35 responses)

A
3% (1)
B
6% (2)
C
80% (28)
D
11% (4)

Explanation

The source data is in a pivoted format where year columns (2020, 2021) are spread across the top, with months as rows. The target shape requires three columns: Month, Sales, and Year - meaning the year column headers must become row values. This is an unpivot operation (C): selecting the year columns and choosing 'Unpivot Columns' in Power Query Editor converts each column header into a value in a new 'Year' column and its corresponding cell value into a 'Sales' column. Pivot Column (D) does the opposite - it turns row values into columns. Transpose (B) rotates the entire table's axes but does not produce the required three-column structure. Merge Columns (A) concatenates columns together, which is irrelevant here.

Community Discussion

No community discussion yet for this question.

Full PL-300 Practice