X
Excel Zero to Hero Interactive Learning Platform
0%
Practice Exercise

Solutions: Exercise 6 (Power Query ETL)

intermediate

Solutions: Exercise 6 (Power Query ETL)

Task 3: Unpivoting Columns

  • In Power Query Editor -> Select EmployeeID -> Right-click -> Unpivot Other Columns -> Rename Attribute to Month and Value to Salary.
💡 Reveal Step-by-Step Solution & Walkthrough (Click to expand)

Solutions: Exercise 6 (Power Query ETL)

Task 3: Unpivoting Columns

  • In Power Query Editor -> Select EmployeeID -> Right-click -> Unpivot Other Columns -> Rename Attribute to Month and Value to Salary.
← Back to Practice Center