Forum Discussion

viralpatel21's avatar
viralpatel21
Helper II
3 years ago
Solved

Transform Table to single view

Hello   I was wondering if you could help me. I have the following table where i have duplicate values.  And i want to display it like the following: ( ive only displayed 2 Riskgroup, but i ...
  • viralpatel21's avatar
    viralpatel21
    3 years ago

    Hello i was able to manage to do it.

     

    In Power query i seperated the table to each groups and then added a custom number to represent the question and did a pivot to a single view.