Showing results for 
Search instead for 
Did you mean: 
oldmancunian Frequent Visitor
Frequent Visitor

complex data manipulation

Hi all, I hope you're all well. I have a dataset that I cannot understand or know how to pivot it to the way that will help me build my dashboard in powerbi. Currently the Years are in column and I would like to bring them in rows.


Currently: Countries are in Rows and years are in columns. 

Desired. I would like to bring years in the rows too.


So my tableau or powerbi can easily process. thank you so much for your kind help. 

elJukes Frequent Visitor
Frequent Visitor

Re: complex data manipulation

Hi @oldmancunian


In the Query Editor, go to the table with countries and years in. Once there highlight all of the columns with years in and then, under the transform menu, select Unpivot Columns.

Community Support Team
Community Support Team

Re: complex data manipulation

HI @oldmancunian,


The simple way is create a matrix visual and drag year column to column fields and category column to axis fields, it will analytics and expand year to multiple column.


You can also consider to use query edit pivot column function to expand one column to multiple columns.



Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |