The code you have is adding the data as the next record in the table, which is what you want.

The issue you have, or what you are seeing, is due to blank records (rows) in your table.

When you put your cursor on the row number at the left of the sheet and click, it highlight the entire row for deletion.
Deleting the entire row removes data from the table and moves the below data up but the number of table records (rows) remains the same, creating blank records at the bottom of the table.

If you put your cursor half on the row number and half in the first column and click, it will highlight only the table record for deletion.
Deleting now will move the remainder of the table up, decreasing the number of table records.