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

Table.FromColumns

Owen Duncan|Last Updated: 4/19/2018

About

Returns a table from a list containing nested lists with the column names and values.

Table.FromColumns(lists as list, optional columns as any) as table  

Arguments

ArgumentDescription
listsThe List of lists to convert.
optional columnsOptional parameter to provide names and types for the columns.

Remarks

  • If some columns have more values then others, the missing values will be filled with the default value, 'null', if the columns are nullable.

Examples

Table.FromColumns({  

    {1, "Bob", "123-4567"} , {2, "Jim", "987-6543"}, {3, "Paul", "543-7890"} })  
Column1Column2Column3
123
BobJimPaul
123-4567987-6543543-7890
© 2018 Microsoft