SOLVED

Power Query Transformation Issue

New Contributor

Hey, I have this state of the Power Query: 

Kretox_0-1654243855620.png

but I would like to transform it to this type of table:

Kretox_1-1654243914107.png
The Power Query would be automatically updating from the web. I suspect I should use Custom Column option but I'm unable to do so. Thanks for any tips!

 

4 Replies

@Kretox 

That could be done with a pivot table.

 

Maybe I should add that I want to make a graph out of that which would automatically update every time I update my data from Power Query. You think that it can be automatized in this way via Pivot Tables?

@Kretox 

Yes, I think so.

 

best response confirmed by Kretox (New Contributor)
Solution

@Kretox 

As variant you may pivot Power Query on Column1 and return aggregation as table, not as PivotTable. Depends on goals.