Microsoft
70-779 · Question #14
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…
Sign in or unlock 70-779 to reveal the answer and full explanation for question #14. The question stem and answer options stay visible for context.
Consume and transform data by using Microsoft Excel
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. What should you do?
Exhibit
Options
- AChange the aggregate value function of the pivot.
- BSelect the ID column, and then click Unpivot Columns
- CChange the Data Type of the Value column.
- DDelete the Picoted Column step. Select the Key column, and the click UnpivotColumns.
Unlock 70-779 to see the answer
You've previewed enough free 70-779 questions. Unlock 70-779 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#pivot columns#aggregate function#Power Query#unpivot