Question 387 of 388
Single answerYou have the CSV file shown in the following table.You use Power Query Editor to preview the data in the file.You need to transform the data to meet the following requirements:- The first column must contain the month.- The second column must contain the year.- The third column must contain the order amount for the month and year.Which transformation should you use first?
✓AremoveB.unpivotC.transposeD.pivot
BAdditional option
✓
Correct Answer: A
removeB.unpivotC.transposeD.pivot
▥
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.