← Back to Table functions

Table.ToList

Transforms a table into a list by utilizing a designated combining function on each row of values within the table.

Syntax

Table.ToList(table as table, optional combiner as nullable function) as list

About

Transforms a table into a list by utilizing a designated combining function on each row of values within the table.

Explanation

Merge the text in each row using a comma. The Power Query code utilizes MTable.ToList function with Table.FromRows method to form a table with rows containing Number.ToText values and strings. The Combiner.CombineTextByDelimiter function is then used to join the text in each row with a comma. The resulting output will be an array of strings with the merged values separated by commas.