Courses / Power Query (Get & Transform)
32. Pivot Columns
Turning row values into columns using Pivot Column and specifying aggregation for duplicates.
Power Query M
Pivot Columns
Turning values in rows into new columns so each unique key becomes a column.
"I have product sales listed by date and product in rows, but I need each product as its own column to compare side-by-side."
Pivot Columns takes a column of keys (the new column headers) and a column of values, and reshapes the table so each key becomes a column; when multiple rows map to the same key you must specify how to aggregate their values.
"I have product sales listed by date and product in rows, but I need each product as its own column to compare side-by-side."
Pivot Columns takes a column of keys (the new column headers) and a column of values, and reshapes the table so each key becomes a column; when multiple rows map to the same key you must specify how to aggregate their values.