function (lists
as list, optionalcolumns
as nullable any) as table
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.Table.FromRecords({[Column1=1,Column2=2,Column3=3],[Column1="Bob",Column2="Jim",Column3="Paul"],[Column1="123-4567",Column2="987-6543",Column3="543-7890"]})
Table.FromRecords({[CustomerID=1,Name=2,Phone=3],[CustomerID="Bob",Name="Jim",Phone="Paul"],[CustomerID="123-4567",Name="987-6543",Phone="543-7890"]})
Table.FromRecords({[column1=1,column2=4,column3=6],[column1=2,column2=5,column3=7],[column1=3,column2=null,column3=8],[column1=null,column2=null,column3=9]})