33 Rows in Google Sheet Tab - Make Google Sheets Add a Row Module is Inserting Data at Row 13 - Why?

How To
1

I have a google sheet with data in:
Cell A1
Header Row in Row 2 (A2:AT2)
There is data in range C3:AT:33
Columns A & B below the header are empty

I am using the Google Sheets Add A Row Function in Make

Whether Table Contains Headers = Yes OR Table Contains Headers = No, I am getting the same behavior.

The Module is set to Insert Rows
Unformatted = No

When running the Add a Row Module for this sheet, the new Row of Data is being inserted at Row #13 instead of at the bottom of the table.

Why? How can I fix this so the data is appended at the bottom of the table as it should be?

3

Please provide a screenshot of the sheet for rows A1-A34.

2 Likes
4

Here you go! Thank you for responding. Starting at Column F, there is data in every column and row going over to AT.

Screenshot
Screenshot804×755 26.6 KB

5

You might have to start from scratch and ensure column A always has data, I suspect that’s how sheets determine a row is empty (available)

2 Likes