Forum Discussion
Solved
Merge or group rows by ID
Appologies, I know what I want but don't know how to search for the solution as I don't know what terminology to use. I would like to merge the contents of six rows into one. A sample of the dat...
Load your data as is into Power BI. Let the Matrix visual do the pivoting.
Thanks @Ibendlin that worked a treat, after a bit of work wrking out that it should be values instead of columns