Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

Which Power Query operation converts cross-tabulated columns into flat rows?

  1. A Unpivot Columns
  2. B Merge Queries
  3. C Append Queries
  4. 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.

All Microsoft excel MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as