A Power Query transform that creates a new column for every distinct value in a column and fills it by aggregating a chosen value column, with Sum as the default or no aggregation. Unpivot reverses it.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Pivot column in context, with comparison tables and the common traps.
Terms in this definition
- ELT
Extract, load, transform: raw data lands in the target system first and is transformed there. See ETL for the opposite order.
- SUM
Totals every numeric value held in one column. Where each row needs its own expression evaluated first, SUMX is needed.
- UNPIVOT
Turns several columns into rows, with one column carrying the former column names and value columns carrying their data; it is the opposite of
PIVOTand needs Databricks Runtime 12.2 LTS or later.