Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Transpose an object table

Hi everyone I know beforehand that there are many posts on this matter "transpose a table", but the table that I am trying to transpose is already in the canvas, and I just want to transpose after do...
General Comment
Need Help
Show and Tell
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    Could you just use a matrix visual and put your field in columns, with nothing in the rows?

     

    If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    Based on your description, I created data to reproduce your scenario.

    Sheet1:

     

    You may try to use a matrix visual with Columns as 'Case A' and Values as 'ID' to display the result.

     

    If you want to do a Transpose in Power Query, you may click 'Transform data', go to 'Query Editor', click 'Transform' ribbon=>'Pivot Column', set as below.

     

    Then you may use a table visual to display the result.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Anonymous 

 

Based on your description, I created data to reproduce your scenario.

Sheet1:

 

You may try to use a matrix visual with Columns as 'Case A' and Values as 'ID' to display the result.

 

If you want to do a Transpose in Power Query, you may click 'Transform data', go to 'Query Editor', click 'Transform' ribbon=>'Pivot Column', set as below.

 

Then you may use a table visual to display the result.

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.