Microsoft Exam PL-300 Topic 4 Question 43 Discussion

You 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?