Table of contents
TOC
Collapse the table of content
Expand the table of content

Table.ToColumns

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

About

Returns a list of nested lists each representing a column of values in the input table.

Table.ToColumns(table as table) as list  

Arguments

ArgumentDescription
tableThe Table to convert.

Example

let  
  
    Source = Table.ToColumns(Table.FromRecords(  
  
{  
  
    [CustomerID = 1, Name = "Bob", Phone = "123-4567"],  
  
      [CustomerID = 2, Name = "Jim", Phone = "987-6543"]  
  
}))  
  
in  
  
    Source  
  
equals  
  
{  
  
    {1, 2},  
  
    {"Bob",  "Jim"},  
  
    { "123-4567", "987-6543"}  
  
}  
© 2018 Microsoft