Posted by: Pdfprep
Post Date: December 21, 2020
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 .
Answer: D
Leave a Reply