Transform Table to single view

[viralpatel21]

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 want to show all the group in a single view)

_au_contactlink_value	Risk Group	Response	Risk Level	Riskscore	Risk Group	Response	Risk Level	Riskscore
f310f664-262a-42db-8853-ac5c634c1e6a	Employment Type	Employed	Low	0	Account Usage	Making Payment to 3rd parties	High	75

thanks

viral

[v-jialluo-msft]

^{Hi @viralpatel21 ,}

^{According to your description, you need to display groupings of data from different rows into one row.}

^{It may not be possible to do the same as the example diagram, but you can achieve a similar effect with matrix visuals:}

^{Best Regards,}

^{Gallen Luo}

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

[viralpatel21 · Accepted solution]

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.