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.

View Answer

Answer: