Transpose data

[Narendra90]

Hi Team,

I want to tranpose horizontal data in vertical form. Please find the input that i have.

Output that i require.

[RajaCSN · Accepted solution]

Hi, I have just simulated your data except the Project names.  Here is the image of the result.  (Please note that I have created a Conditional Column in the PQE to sort the months).

You can download the file on which I have worked here:

Unpivot and Transpose with SortColumn Sample.pbix

If this sample is found to be helpful, please accept it as a solution which could help others too. Your Kudo's are welcome. 

Best,

C.S.N. Raja

[Narendra90]

would you please share the sample data here

[RajaCSN]

Hi, I had provided the link in my reply. Hope you are able to download the PBIX file. Please check and confirm. 

[Narendra90]

can download power bi file. need to see actual raw data that you have created. so i can manage my accordingly. thanks for your help

[RajaCSN]

As I said, I have just simulated your sample data in an Excel sheet. Here is the image of my excel table:

If the suggestions provided by me are useful, please consider "Accept" as a solution. 

Best,

C.S.N. Raja

[Ahmedx]

pls see my video

Transpose data.mp4

[Narendra90]

Thank you very much both of you ... both solution works very wells 🙂