Insert New Row in Excel Power Query

[legalhustler]

I have a table with 15 columns in Excel Power Query and want to add a new first row in my table called "Summer", but I only want "Summer to appear in column 1, row 1 and the rest of the row should be empty. Will need to display the rest of the (15) columns after the new row has been added. How can I achieve this?

 

[JGordon11]

Change 0 to Table.RowCount(Source)

 

[legalhustler]

Change 0 to Table.RowCount(Source)

Perfect! Just the function I needed to make it dynamic.