You can remove all the empty rows. The problem with Google is that they see empty rows as valid rows and skips them when writing new ones to the Sheet.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Arrayformula storage issue | 23 | 1934 | February 4, 2024 | |
| Form Entries appear on the bottom of the spreadsheet | 4 | 1006 | December 30, 2019 | |
| Doesn't write on my Google Sheet | 5 | 1862 | February 4, 2024 | |
| Big forms. Bug or limitation? | 5 | 247 | August 24, 2022 | |
| User input data goes in row 455 rather than next empty row | 5 | 945 | September 12, 2020 |