Adding row to another table adding rows after blank spaces

[Jennifer_Cook]

I'm having an issue with the data action adding rows to another table using rows from this table. When the button is clicked, the rows are added to the new table; however, they are added after blank spaces. Sheet 1, where the data is coming from is inside an application. Sheet 2, is just a connection to a spreadsheet that we are still using in spreadsheet form. In this sheet, we have blank rows at the bottom where nothing has been entered yet. Previously, we had the patient ID as the key. When this was the case, the app would add the information to the highest row number that was blank. We had to change the Key because we needed to have multiple entries for one patient, so we made the key a dual key of patient ID and date. Now, the app creates a new row at the bottom of the spreadsheet and adds in the data, ignoring several blank rows above it. How do I fix this?

Edit: I've also tried to create a calculated field with UNIQUEID() and I get the same results.