title: copy data from one sheet to another in google app script and append a row, one small issue
body: <p>sure I had this down but just can't get it right. Had a script set up to get data from one sheet and put it into another one, which I have done but it leaves gaps when copying and I can't figure out how to solve it. I'm sure in the code, its where I have put a question mark, is where the problem lies.</p>
  
  <p>I have tried put i, last, last+1, 10, 12 but none of these work, feel like i'm missing something small to get this right. Below is the code a link to view the sheet if needed (the sheet is just for me to learn from, a basic example if you will).</p>
  
  <p>Thanks in advance and also if the code could be better written, please just let me know as still learning this :) </p>
  
  <pre><code>function copyInfo() {
    var app = SpreadsheetApp;
    var copySheet = app.getActiveSpreadsheet().getSheetByName("Copy");
    for (var i = 2; i &lt;12; i++) {   
    var getInfo = copySheet.getRange(2,2,i,2).getValues();
    //  get the info from range above - start at row 2 on column 2 (b), get number of rows i , number of columns = 2, b,c 
    var last = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Paste").getLastRow();
    var pasteSheet = app.getActiveSpreadsheet().getSheetByName("Paste");
  //  Tell it where you want the info to go to 
  
    pasteSheet.getRange(last+1,1,?,2).setValues(getInfo);
    var clearIt = copySheet.getRange(2,2,i,2).clearContent();  
  // this clears the copy range aka getInfo
    }}
  </code></pre>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1pOmDQigS3B-V3hHLHl1EvlGL3pNmWEMDA-W8r6snV4U/edit?usp=sharing" rel="nofollow noreferrer">link to sheet</a></p>