Table.FromColumns

Syntax

Table.FromColumns(lists as list, optional columns as any) as table

Description

Creates a table of type columns from a list lists containing nested lists with the column names and values. If some columns have more values then others, the missing values will be filled with the default value, ‘null’, if the columns are nullable.

Reference Data

https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

Power Query M Functions / Table Functions / Table.FromColumns