Forum Discussion
Re-modelling datas imported from the web
Hello everyone,
I managed to obtain the data I wanted from the UNdata API, but they are not like I want them to be and I struggle to do it. As you can see, the first column's rows contain the column headers and the second column is the value of these column header... And it's the same for the rest of the table : the third column rows are supposed to be a single column and the fourth column contain the value of this single column.
It a bit difficult to explain, I hope you understanded me.
Thanks in advance for the help
Hi,
You'll find all functionalities to do the job in Power Query. (Button Transform Data).
You can suppress lines on top or bottom, Promote Headers (using first line as headers),
Unpivot some columns if needed...
And so on...
Have a look at and so many others...
https://www.youtube.com/watch?v=AGrl-H87pRU
Have a nice day
3 Replies
Hi,
You'll find all functionalities to do the job in Power Query. (Button Transform Data).
You can suppress lines on top or bottom, Promote Headers (using first line as headers),
Unpivot some columns if needed...
And so on...
Have a look at and so many others...
https://www.youtube.com/watch?v=AGrl-H87pRU
Have a nice day