Forum Discussion
Solved
Combine text from multiple columns in Power Query
Here's a table with the results I seek: col_1 col_2 result ape bee ape,bee house street house,street Now I have something like this (see below), where I collect eac...
Try this as the next step:
= Table.AddColumn(#"Merged Columns", "Custom", (r) => Text.Combine(List.Transform(MyColumns, each Record.Field(r, _)), ","), type text)This turns the list of columns into the values in those columns and concatenates the list with Text.Combine.
Yes. There's nothing special about the letter "r" but I needed to give it a name so that I could distinguish between the list environment and the row (record) environment when writing Record.Field(r, _).
Understood, thanks for the explanation!