Forum Discussion
Solved
Data Transform: consolidating same value format
Hello team, Looking for help transforming the data in this file. It should be a simple excercise but I am missing a couple of steps. Appreciate you help. GR.
Hi,
In power query:
- Duplicate the table twice so you have 3 copies.
- On each one select 3 of the columns for a catagory (Attribute, Ratio or Multiple) then unpivot them
- Delete the other categories on each that you haven't unpivoted on each table and rename the columns in attribute and value with an appropriate name and number e.g Category 1 & Value 1, Category 2 & Value 2 etc
- Return to you main table and use merge queries to combine the other 2 tables selecting Widgets, Qtr & Maturity Qtr as matching columns on both
- Expand the table and only bring through the Category and value columns
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
In power query:
- Duplicate the table twice so you have 3 copies.
- On each one select 3 of the columns for a catagory (Attribute, Ratio or Multiple) then unpivot them
- Delete the other categories on each that you haven't unpivoted on each table and rename the columns in attribute and value with an appropriate name and number e.g Category 1 & Value 1, Category 2 & Value 2 etc
- Return to you main table and use merge queries to combine the other 2 tables selecting Widgets, Qtr & Maturity Qtr as matching columns on both
- Expand the table and only bring through the Category and value columns
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍