Forum Discussion
Transform Data from Report into Table: what should I use Power Query, Macro?
Good afternoon all! This is my first post in this forum, thanks in advance for the help! I use a system where I can extract the following report with the following information, let's call it ...
Thanks! I'm opened the file and I'm trying to understand the steps you applied.
Could you further explain?
Thanks!
Could you further explain?
Thanks!
After opening the Power Query Editor you can view all the applied steps of the query. You can click on any step to view the updated data.
Some steps have gear icons. You can click on this icon to view further information on the applied step.
If you are interested in Power Query you could start with this introduction.
Introduction to Power Query - Excel Off The Grid