Forum Discussion
Insert blank row at the end
I can insert a blank row using this code: = Table.InsertRows(Source, 0,{Record.FromList(List.Repeat({""},Table.ColumnCount(Source)),Table.ColumnNames(Source))}) but the zero inserts at the ...
Replace the "0" with Table.RowCount(Source). This will give you the row count, which is one more than the zero based index of the last row.
--Nate
Replace the "0" with Table.RowCount(Source). This will give you the row count, which is one more than the zero based index of the last row.
--Nate