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

Table.FromRows

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

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.

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

Arguments

ArgumentDescription
rowsThe List to convert.
optional columnsAn optional list of column names, or a table type.

Example

Table.FromRows({{1, "Bob", "123-4567"} , {2, "Jim", "987-6543"}}, {"CustomerID ", "Name", "Phone"})  
CustomerIDNamePhone
1Bob123-4567
2Jim987-6543
© 2018 Microsoft