Power Query Transformation Issue

New Contributor

Hey, I have this state of the Power Query: 


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

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


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?


Yes, I think so.


best response confirmed by Kretox (New Contributor)


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