function (table
as table,offset
as number,rows
as list) as table
rows
, inserted into the table
at the given position, offset
. Each column in the row to insert much match the column types of the table.Table.FromRecords({[CustomerID=1,Name="Bob",Phone="123-4567"],[CustomerID=3,Name="Paul",Phone="543-7890"],[CustomerID=2,Name="Jim",Phone="987-6543"]})
Table.FromRecords({[CustomerID=1,Name="Bob",Phone="123-4567"],[CustomerID=2,Name="Jim",Phone="987-6543"], [CustomerID=3,Name="Paul",Phone="543-7890"]})