Table.FromRows

About

Creates a table from the list rows where each element of the list is an inner list that contains the column values for a single row. An optional list of column names, a table type, or a number of columns could be provided for columns.

Syntax

Table.FromRows(rows as list, optional columns as any) as table  

Arguments

Argument Description
rows The List to convert.
optional columns An optional list of column names, or a table type.

Example

Table.FromRows({{1, "Bob", "123-4567"} , {2, "Jim", "987-6543"}}, {"CustomerID ", "Name", "Phone"})  
CustomerID Name Phone
1 Bob 123-4567
2 Jim 987-6543