You have a workbook query that loads the following table.

You have a workbook query that loads the following table.

You pivot the table on the key column by using value as the values column, and you receive the results shown in the following table.

You need to ensure that the data appears as shown in the following table.

A . Change the aggregate value function of the pivot.
B . Select the ID column, and then click Unpivot Columns
C . Change the Data Type of the Value column.
D . Delete the Picoted Column step. Select the Key column, and the click UnpivotColumns .

View Answer

Answer: A