1

I'd like to be able to convert text over multiple rows with a common field to a single field over multiple columns.

from this: enter image description here to this: enter image description here

Any help greatly appreciated!!

dhilmathy
  • 2,800
  • 2
  • 21
  • 29
Chris
  • 11
  • 1
  • 1
    Possible duplicate of [PowerQuery: How can I concatenate grouped values?](https://stackoverflow.com/questions/44058355/powerquery-how-can-i-concatenate-grouped-values) – Alexis Olson Aug 15 '18 at 15:07

1 Answers1

0

It's very easy =)

enter image description here

let
    src = #table({"col1", "col2"}, {
        {"1","a"},{"1","b"},{"1","c"},
        {"2","a"},{"2","b"},{"2","c"}}
    ),
    grouped = Table.Group(src, {"col1"}, {{"col2", each Text.Combine([col2], ",")}})
in
    grouped

enter image description here

Sergey Lossev
  • 1,430
  • 10
  • 20