Apps Script: Move duplicates to another sheet instead of deleting them

Question

I found this amazing masterpiece of @Cooper to search for duplicates based on values in 1 column. Now instead of removing these duplicates as the code does, I want to move them to another sheet. Any idea how this can be done?

Thanks :).

Here is the code:

function removeDuplicates() {
  var sh=SpreadsheetApp.getActiveSheet();
  var dt=sh.getDataRange().getValues();
  var uA=[];
  var d=0;
  for(var i=0;i<dt.length;i++) {
    if(uA.indexOf(dt[i][0])==-1) {
      uA.push(dt[i][0]);
    }else{
      sh.deleteRow(i+1-d++);
    }
  }
}

Cooper · Accepted Answer · 2022-01-09 21:09:36Z

1

Move row

function removeDuplicates() {
  const ss = SpreadsheetApp.getActive();
  const dsh = ss.getSheetByName('Destination');
  var sh=SpreadsheetApp.getActiveSheet();
  var dt=sh.getDataRange().getValues();
  var uA=[];
  let d = 0;
  for(var i=0;i<dt.length;i++) {
    if(uA.indexOf(dt[i][0])==-1) {
      uA.push(dt[i][0]);
    }else{
      dsh.appendRow(dt[i]);//append
      sh.deleteRow(i+1-d++);//delete 
    }
  }
}

answered Jan 9, 2022 at 21:09

Cooper

64.2k7 gold badges29 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Apps Script: Move duplicates to another sheet instead of deleting them

1 Answer 1

Move row

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Move row

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related