Forum Discussion
Solved
How to transform like rows into like columns of data
I'm looking to take my table of values that has similar terms in the one column and group those terms and their respective data into columns of their own. My goal is to...
NewStep=let a=Table.Group(PreviousStepName,"Name",{"n",each [Merged]}) in Table.FromColumns(a[n],a[Name])
Thank you so much, I've spent far too many hours trying to figure this out on my own!
I'm still just learning to code in M, would you be able to provide any further explanation so I might better understand this solution?