1. 1

    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?

  2. 2

    Is this data a good candidate to be unpivoted?

  3. 3

    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?