how to merge by rows?

[yishenhui]

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 be merged. the expected result is like the other. (or the joined field can be separated if the first solution not possible).

Thanks.

[artemus · Accepted solution]

You will need to use a custom group aggregate:

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