Question

You import a small reference table from Excel where each metric is stored as a separate row (columns: Metric, Value) — for example rows for 'Population', 'Area', and 'GDP' per region. The report authors need each metric to become its own column while keeping one row per region. Which Power Query transformation should you apply to achieve this without hard-coding metric names?

Accepted Answer

Select the Metric column and use Pivot Column, with Value as the values column and 'Don't Aggregate' as the aggregation

Answer

Select the Value column and use Pivot Column, choosing Metric as the values column and Value as the aggregate

Answer

Select all columns and use Unpivot Columns to normalize the table

Answer

Use Transpose to flip the entire table so rows become columns