Forum Discussion

OSS's avatar
OSS
Icon for Helper III rankHelper III
7 years ago
Solved

Create Pivot table

Dear members I have source table which I would like to turn in pivot table. Since my source table is formed from different table columns I cant use simple pivot function. Matrix view is not a chois...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, OSS 

    Do mean that the three columns are from different table and you haven't put them into one table like this:

    If so you need to put them into one table, use Merge queries function in edit query to merge basic tables and then remove the other columns to get a table that contains these three columns.

    then pivot the table as below:

    Select Origin column click Transform -> Pivot column

    Result:

     

    Best Regards,

    Lin

     

     

     

     

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, OSS 

Do mean that the three columns are from different table and you haven't put them into one table like this:

If so you need to put them into one table, use Merge queries function in edit query to merge basic tables and then remove the other columns to get a table that contains these three columns.

then pivot the table as below:

Select Origin column click Transform -> Pivot column

Result:

 

Best Regards,

Lin

 

 

 

 

OSS's avatar
OSS
Icon for Helper III rankHelper III
7 years ago

v-lili6-msft Thank you very much. This is exactly what I was looking for.