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:
- _ 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