Forum Discussion

yishenhui's avatar
yishenhui
Icon for Helper II rankHelper II
3 years ago
Solved

how to merge by rows?

Hi,   I want to merge field value together with rows. like the reverse operation of "split column to rows". For example below, the table has two columns, one is group, the other is the one need to ...
Need Help
  • artemus's avatar
    artemus
    3 years ago

    You will need to use a custom group aggregate:

    Table.Group(previousStep, {"group"}, {{"joined", each Text.Combine([#"field 1"], " ")}})
artemus's avatar
artemus
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

You will need to use a custom group aggregate:

Table.Group(previousStep, {"group"}, {{"joined", each Text.Combine([#"field 1"], " ")}})