Table.FromColumns

About

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

Syntax

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

Arguments

Argument Description
lists The List of lists to convert.
optional columns Optional 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"} })  
Column1 Column2 Column3
1 2 3
Bob Jim Paul
123-4567 987-6543 543-7890