https://community.fabric.microsoft.com/t5/Desktop/Columns-to-Rows-with-sample-data/m-p/297370#M131237 <P>Anonymous</LI-USER></P><P>&nbsp;</P><P>Hi, in Edit Query Select Columns&nbsp;Sales Person &amp; Client&nbsp; and go to Transform - UnPivot other Columns.</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Regards</P><P>&nbsp;</P><P>Victor</P> Mon, 06 Nov 2017 17:54:53 GMT Vvelarde 2017-11-06T17:54:53Z https://community.fabric.microsoft.com/t5/Desktop/Columns-to-Rows-with-sample-data/m-p/297359#M131236 <P>I am working with a dataset in which each month is a separate column.&nbsp; 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.</P><P>&nbsp;</P><P><A title="Months to Rows Instead of Column" href="https://www.dropbox.com/s/wldqjl3vjqh1h7t/Sample%20Data%20Months%20to%20Column.xlsx?dl=0" target="_self">https://www.dropbox.com/s/wldqjl3vjqh1h7t/Sample%20Data%20Months%20to%20Column.xlsx?dl=0</A></P><P>&nbsp;</P><P>I would apprecuate some insight on how to best transform this dataset.</P><P>&nbsp;</P><P>Thanks!</P> Mon, 06 Nov 2017 17:33:03 GMT https://community.fabric.microsoft.com/t5/Desktop/Columns-to-Rows-with-sample-data/m-p/297359#M131236 Anonymous 2017-11-06T17:33:03Z https://community.fabric.microsoft.com/t5/Desktop/Columns-to-Rows-with-sample-data/m-p/297370#M131237 <P>Anonymous</LI-USER></P><P>&nbsp;</P><P>Hi, in Edit Query Select Columns&nbsp;Sales Person &amp; Client&nbsp; and go to Transform - UnPivot other Columns.</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Regards</P><P>&nbsp;</P><P>Victor</P> Mon, 06 Nov 2017 17:54:53 GMT https://community.fabric.microsoft.com/t5/Desktop/Columns-to-Rows-with-sample-data/m-p/297370#M131237 Vvelarde 2017-11-06T17:54:53Z