Combiner functions
The Power Query Formula Language is a powerful query language optimized for building queries that mashup data. It's a functional, case sensitive language similar to F#, which can be used with Power Query in Excel, Get & Transform in Excel 2016, and Power BI Desktop. To learn more, see the PowerQueryName reference.
Combiner functions are used by other library functions that merge values, such as Table.ToList and Table.CombineColumns. The function is applied to each row in the table to produce a single value for each row.
| Function | Description |
|---|---|
| Combiner.CombineTextByDelimiter | Returns a function that combines a list of text into a single text using the specified delimiter. |
| Combiner.CombineTextByEachDelimiter | Returns a function that combines a list of text into a single text using each specified delimiter in sequence. |
| Combiner.CombineTextByLengths | Returns a function that merges a list of text into a single text. |
| Combiner.CombineTextByPositions | Returns a function that merges a list of text into a single text. |
| Combiner.CombineTextByRanges | Returns a function that merges a list of text into a single text. |
Show: