Copying data from a sheet to another with conditions

I have been trying to copy some data from a sheet to another but I have been running into some trouble.

If your data doesn't have any blank rows in between the first row and last non-empty row, then you can use this:

Sample Data:

sheet1

sheet2

Script:

function copyInfo() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var copySheet = ss.getSheetByName("sheet1");
  var pasteSheet = ss.getSheetByName("sheet2");
  // get last rows of each sheet
  var sLastRow = copySheet.getLastRow();
  var dLastRow = pasteSheet.getLastRow();

  // get data from sheet1 from row 11 to last row
  var source = copySheet.getRange(11,1,sLastRow - 10,10).getValues();  
  // paste data to sheet2's last row
  pasteSheet.getRange(dLastRow + 1,1,source.length,source[0].length).setValues(source);
}

Output:

Alternative:

If you have blank rows in between your sheet1, you can filter the values in sheet1.

Sample Data:

blank row 13 in sheet1

function copyInfo() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var copySheet = ss.getSheetByName("sheet1");
  var pasteSheet = ss.getSheetByName("sheet2");
  // get last rows of each sheet
  var sLastRow = copySheet.getLastRow();
  var dLastRow = pasteSheet.getLastRow();

  // get data from sheet1 from row 11 to last row
  // exclude rows with blank values in all columns
  var source = copySheet.getRange(11,1,sLastRow - 10,10).getValues()
                        .filter(row => row.filter(col => !col).length < row.length);    
  // paste data to sheet2's first blank row
  pasteSheet.getRange(dLastRow + 1,1,source.length,source[0].length).setValues(source);
}

Output: