Data Transpose

Question

&nbsp;Hello friends,&nbsp;can you please help me on how to translate the data shown below&nbsp;Project &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Area1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Area2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Area3&nbsp;P100 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22500 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2200 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 45000T010 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4500 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 37000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 480000&nbsp;to&nbsp;Area1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22500Area2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2200Area3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;45000&nbsp;filtered by Project.

marcelbeug · Answer

In the Query Editor, choose your Project column, right-click and select "Unpivot Other Columns".

vijayghatti · Answer

Thanks for the quick revert.&nbsp;can you please check the screenshots and help

marcelbeug · Answer

Awaiting your screenshots...

v-yulgu-msft · Answer

Hi&nbsp;vijayghatti,
&nbsp;
In query editor mode, select [Project] column, then, unpivot other columns.

&nbsp;

&nbsp;
To filter data by project, you only need to insert column [Project] into slicer.
&nbsp;
If you still have any question, please feel free to ask.
&nbsp;
Best regards,Yuliana Gu

vijayghatti · Answer

Thank you for the help.&nbsp;i was able to do the things as per the steps explained, how ever&nbsp;let me try to explain the senario.&nbsp;i have a view&nbsp;which has the metadata that is required for the report&nbsp;and a table which has the list of projects, both are from SQL server.now i imported the data and followed the steps as said, but i am not able to show the output in the way that was desired to be.&nbsp;.&nbsp;screenshot 3 is the expected format and also i need to show the percentage of values in another column.hope this clarifies.&nbsp;thanksVijay

Forum Discussion

Data Transpose

6 Replies

Related content

Help Transposing

Transpose data

Transposing Data

Transpose data

Transpose data in table visual