title: Copy and paste a Row and delete certain cells
body: <p>I am trying to copy paste a row (A3:S3) to the next free row of my sheet.
  This works fine with the following code. 
  What I am now trying to do is to delete the cells C3-K3.</p>
  
  <pre><code>function copypastescript() {
  var reference = 'Definitionstabelle!A2'; 
      var rng = SpreadsheetApp.getActiveSpreadsheet().getRange(reference);
      rng.setValue(rng.getValue()+1);
      var ss = SpreadsheetApp.getActiveSpreadsheet ();
      var ss = SpreadsheetApp.getActiveSpreadsheet ();
    var source = ss.getRange ("Definitionstabelle!A3:S3");
      var destSheet = ss.getSheetByName("Definitionstabelle");
      var values = source.getValues().filter(function(e) {return e.some(function(f) {return f})});
  destSheet.getRange(destSheet.getLastRow() + 1, 1, values.length, values[0].length).setValues(values);
  }
  </code></pre>