You have a table in Power BI Desktop as shown in the following exhibit.
You pivot the columns as shown in the following exhibit.
You need to resolve the error in row 3. The solution must preserve all the data.
What should you do?
A. Change the Data Type of the Value column.
B. Select the Key column, and then click Remove Duplicates.
C. Change the Aggregate Value Function of the pivot.
D. Select the Score column, and then click Remove Errors.
