Forum Discussion
yishenhui
Helper II
Helper IIhow 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 be merged. the expected result is like the other. (or the joined field can be separated if the first solution not possible).
Thanks.
You will need to use a custom group aggregate:
Table.Group(previousStep, {"group"}, {{"joined", each Text.Combine([#"field 1"], " ")}})
1 Reply
artemusMicrosoft Employee
You will need to use a custom group aggregate:
Table.Group(previousStep, {"group"}, {{"joined", each Text.Combine([#"field 1"], " ")}})