If you are using arrayformulas, be sure to delete any empty rows. Any rows that have any formulas in them will be considered filled rows and new data will be written on the first available empty row.
1 Like