Courses / Power Query (Get & Transform)
33. Unpivot Columns
Normalizing wide tables by unpivoting selected columns into attribute/value rows.
Power Query M
Unpivot Columns
Turning multiple columns of the same kind into rows of attribute/value pairs so the table is normalized.
"I have separate Month columns and need them as rows so I can filter, group, and chart by month."
Unpivot converts selected columns into two columns (Attribute and Value), collapsing wide repeated fields into many rows and keeping other columns as identifiers.
"I have separate Month columns and need them as rows so I can filter, group, and chart by month."
Unpivot converts selected columns into two columns (Attribute and Value), collapsing wide repeated fields into many rows and keeping other columns as identifiers.