If you have any empty rows in Sheet1, you end up with a bunch of empty rows between each appended range. I like to solve this problem with the QUERY function. The QUERY function uses SQL-like statements to effectively query a range of data in Google Sheets as though it were a table in a database.
For More Information Please Refer:
You May Also Like to Read: