Forum Discussion

Anonymous

Not applicable

8 years ago

Solved

convert columns into rows. Not Unpivot....I think....

My query is producing the results below. Is there a way to convert it so that I have a single row for clashName 149 and all the left column values are spread out to its right, one on a separate colum...

kamran_bsh
8 years ago
Hi

If I understand correctly, please use below steps

First Group by Clash name and under operation use All rows

Then add a custom column using formula:

Text.Combine([Count][clashresults],", ")

This should give you the result you want.

Regular Visitor

8 years ago

Hi

If I understand correctly, please use below steps

First Group by Clash name and under operation use All rows

Then add a custom column using formula:

Text.Combine([Count][clashresults],", ")

This should give you the result you want.