Forum Discussion
Solved
Power Query Transformation Issue
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!
As variant you may pivot Power Query on Column1 and return aggregation as table, not as PivotTable. Depends on goals.
4 Replies
As variant you may pivot Power Query on Column1 and return aggregation as table, not as PivotTable. Depends on goals.
- 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?
