Search for courses or lessons
Redeem a coupon
Start free trial
You set up a query to unpivot the data shown in the image below as follows: Pull the data into Power Query --> Right click the Customer column --> Unpivot Other Columns. What will happen when you refresh the query if the original table is updated to have columns for Product 5, Product 6 and Product 7?
The columns for Product 1 through Product 4 will pivot, but the new columns will not
The newly added columns will be unpivoted as well
The query will break as the data source has changed
Is this data a good candidate to be unpivoted?
No, it is already unpivoted
It could be if you transposed it first
You are building a query that will unpivot a data set, and your intention is to use this table to drive several PivotTables. What should you ensure is removed from the data when you build the query?
Totals and subtotals
We shouldn’t remove anything
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement