Which Power Query operation converts cross-tabulated columns into flat rows?
- A Unpivot Columns
- B Merge Queries
- C Append Queries
- D Group By
Answer
Unpivot Columns
Unpivoting turns twelve month columns into a month column and a value column, which is the shape PivotTables and data models require.





