Unpivot - Power Query
14-August-2022
A couple of weeks ago I need to turn in some information and part of that information was not pass to me in time when the information finally came into my inbox. I was very late so I work automatically with out thinking a bit, but know I have a little more time to build it.
What do I need to do ?
Get the report with an updated version of the same file. The main problem with that document is its format
The final format is the other way around with a column by month and a column for the amount
How to do it?
Make the original file a Table.
a. Select the cells
b. go to Insert tables
Make a power query
a. go to data
b. go to from Table/Range
3. This opens a power query editor
3. 1 Select the columns that will be turn to rows as columns (with control or shift)
3.2 go to Transform tab
3.3 Select unpivot columns
The table now looks lite this with an attribute column that contains in each row the name of the columns where the value was at
4. Close and Load
Finish result
With that you get the finish layout with unpivot data
if you get the same format table you can just replace the original table and will update your query table
