function copytestdata() {

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet1 = ss.getSheetByName("test_air");
  var sheet2 = ss.getSheetByName("skaiciavimai");

  sheet1.getRange("A:A").copyTo(sheet2.getRange(sheet2.getLastColumn()+1,1), {contentsOnly:true});
  sheet1.getRange("D:D").copyTo(sheet2.getRange(sheet2.getLastColumn()+1,2), {contentsOnly:true});

}