Comment on page
Table.ToColumns
Creates a list of nested lists of column values from a table.
function (table
as table) as list
Creates a list of nested lists from the table,
table
. Each list item is an inner list that contains the column values.Table.Conversions
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"} }
Last modified 5yr ago