Question

You import a table from a survey system into Power Query. Each respondent has multiple rows, one per attribute, with columns named RespondentID, AttributeName (containing values like 'Age', 'Region', 'Score'), and AttributeValue. Your report requires one row per respondent with Age, Region, and Score as separate columns. Which Power Query transformation should you apply?

Accepted Answer

Select the AttributeName column and use Pivot Column, choosing AttributeValue as the values column.

Answer

Select the AttributeName and AttributeValue columns and use Unpivot Columns.

Answer

Group by RespondentID and aggregate AttributeValue using the Count operation.

Answer

Use Transpose to switch the rows and columns of the entire table.