Question 365 of 388
Single answerYou 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- YearWhat should you select in Power Query Editor?
✓AMerge columnsB.TransposeC.Unpivot columnsD.Pivot column
BAdditional option
✓
Correct Answer: A
Merge columnsB.TransposeC.Unpivot columnsD.Pivot column
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.