Combiners
Combiners merge text values from a list or columns within a table to form a single text value. Whether concatenating first and last names to create full names or joining address components into a complete address, combiners are essential in everyday scenarios where separate elements need to be brought together to create something more meaningful. The same principle applies to transformation scenarios, where merging columns before additional transformations, such as unpivoting, is crucial to ensure that related values remain together throughout the process. This provides the means to separate these combined values again, at a later stage in the transformation process.
In the Power Query M language, combiners join a list of text values into a single text. They are utilized by higher-order standard library functions such as Table.ToList and Table.CombineColumns, which use a combiner function to process each row in a table and produce a single value per row.
A common...
