70-779 Exam Dumps | You have a workbook query that loads the following table. (Exhibit) You pivot the table on the key column

<< Prev Question Next Question >>

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. Delete the Picoted Column step. Select the Key column, and the click UnpivotColumns.

B. Change the Data Type of the Value column.

C. Select the ID column, and then click Unpivot Columns

D. Change the aggregate value function of the pivot.

Download PDF File