cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
irnm8dn Member
Member

Columns to Rows (with sample data)

I am working with a dataset in which each month is a separate column.  I would like them, that the repspective data to have months as a single column, so that I can use it properly as an axis.

 

https://www.dropbox.com/s/wldqjl3vjqh1h7t/Sample%20Data%20Months%20to%20Column.xlsx?dl=0

 

I would apprecuate some insight on how to best transform this dataset.

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Columns to Rows (with sample data)

@irnm8dn

 

Hi, in Edit Query Select Columns Sales Person & Client  and go to Transform - UnPivot other Columns.

 

Unpivot.png

 

Result.png

 

Regards

 

Victor




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




1 REPLY 1
Super User
Super User

Re: Columns to Rows (with sample data)

@irnm8dn

 

Hi, in Edit Query Select Columns Sales Person & Client  and go to Transform - UnPivot other Columns.

 

Unpivot.png

 

Result.png

 

Regards

 

Victor




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!