How should you transform the data from Query Editor?

HOTSPOT
You have a workbook query that uses an Excel data source. The data source contains the following table

You need the data to appear as shown in the following table.

How should you transform the data from Query Editor? To answer, select the appropriate options in the answer area NOTE: Each correct selection is worth one point
Hot Area:

microsoft-exams

4 thoughts on “How should you transform the data from Query Editor?

  1. This is also incorrect. The correct answer is TestScoreA/B/C and Unpivot. Even the reference link tells you to click on the values, not the anchor pieces of information

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.