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 ...
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?
