Power Query
published
Search
⌃K

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"} }