HOTSPOT
You have a query that uses a Microsoft Excel data source. The data source contains the following table.
You need the data to appear as shown in the following table.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
The correct answer is
– 2014, 2015, 2016 and 2017
– Unpivot Columns
I recreated the test on my own machine.