Merging of all columns in Power Query – regardless of their names

This article describes, how to merge all columns in Power Query – not referencing their names.

The Custom column syntax looks like this:

= Text.Combine(
      List.Transform(
         Record.FieldValues(_),
         Text.From),
      “,”)

Because:

• _ Underscore takes the record, containing values in row
• Record.FieldValues (_) creates list from it
• List.Transform takes this list and makes texts from its values. If you are sure that values are text only, you don´t have to use List.Transform
• Text.Combine takes the modified list and merges its values, using comma