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.
What should you do?
A. Change the Aggregate Value Function of the pivot
B. Change the Data Type of the Value column
C. Select the ID column, and then click Unpivot Columns
D. Delete the Pivoted Column step. Select the Key column, and then click Unpivot Columns
A. is correct
yup, A is correct, change the Aggregate Value to don’t aggregate
Correct is A.