Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Syntax
Table.ToColumns(table as table) as list
About
Creates a list of nested lists from the table, table. Each list item is an inner list that contains the column values.
Example 1
Create a list of the column values from the table.
Usage
Table.ToColumns(
Table.FromRecords({
[CustomerID = 1, Name = "Bob", Phone = "123-4567"],
[CustomerID = 2, Name = "Jim", Phone = "987-6543"]
})
)
Output
{{1, 2}, {"Bob", "Jim"}, {"123-4567", "987-6543"}}