How can I append multiple rows from source sheet to destination sheet; select columns like A,C,H ? source sheet columns A-Z, with multiple rows. destination sheet - append rows from source sheet - select columns A, C and H only. Thank you

CodePudding user response：

Transfer Data from one sheet to another selecting only columns A,C and H

function xferdata() {
  const ss = SpreadsheetApp.getActive();
  const ssh = ss.getSheetByName("Sheet0");
  const dsh = ss.getSheetByName("Sheet1");
  const vs = ssh.getRange(2,1,ssh.getLastRow() - 1, 8).getValues();
  let o = vs.map(([a,,c,,,,,h]) => [a,c,h]);
  //Logger.log(JSON.stringify(o));
  dsh.getRange(dsh.getLastRow()   1,1,o.length,o[0].length).setValues(o);
}

Sheet0:

Sheet1: