Table.FromRows
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
| Argument | Description |
|---|---|
| rows | The List to convert. |
| optional columns | An optional list of column names, or a table type. |
Table.FromRows({{1, "Bob", "123-4567"} , {2, "Jim", "987-6543"}}, {"CustomerID ", "Name", "Phone"})
| CustomerID | Name | Phone |
|---|---|---|
| 1 | Bob | 123-4567 |
| 2 | Jim | 987-6543 |
Show: