Table.FromColumns
This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.
Returns a table from a list containing nested lists with the column names and values.
Table.FromColumns(lists as list, optional columns as any) as table
| Argument | Description |
|---|---|
| lists | The List of lists to convert. |
| optional columns | Optional parameter to provide names and types for the columns. |
- If some columns have more values then others, the missing values will be filled with the default value, 'null', if the columns are nullable.
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 |
Show: