Table.ToRows
A table's rows as a list of lists, each row's values in column order.
Group: Table. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Table.ToRows(table as table) as list| Parameter | Type | Description |
|---|---|---|
table | table | The table to take apart. |
Returns
list. A list per row, in the table's order.
Remarks
- The column names are not part of it;
Table.FromRowsbuilds a table from such a list and the names.
Examples
Two rows
Table.ToRows(#table({"Product", "Price"}, {{"Chair", 50}, {"Desk", 120}})){{"Chair", 50}, {"Desk", 120}}