Table.ToColumns

Table.ToColumns
Creates a list of nested lists of column values from a table.
function (table as table) as list
Description
Creates a list of nested lists from the table, table. Each list item is an inner list that contains the column values.
Category
Table.Conversions
Examples
Create a list of the column values from the table.
Table.ToColumns(Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"],  [CustomerID = 2, Name = "Jim", Phone = "987-6543"] }))
{ {1, 2},{"Bob", "Jim"},{ "123-4567", "987-6543"} }

Table.SplitColumn

Table.ToList

Last modified 4yr ago