title: increment by letter in google-apps-script
body: <p>I have data in multiple columns from rows 3-15.  I want to find all the unique values in that data set and have it outputted in one column.</p>
  
  <p>The unique function only does one column at a time so it does not work for my purposes.</p>
  
  <p>I am writing a script that will open a new sheet and copy and paste the values into the same column (combines data from multiple columns into one longer column).  I will then run the unique function on the single column containing all the data to get an output of all the unique values in my original dataset (Items!B3:Z15)</p>
  
  <p>I have the code written but cannot figure out how to increment a character.  If there is a better way to achieve this I am open to suggestions, but I am also curious if it is possible to increment letters.</p>
  
  <p>Thanks for the help, here is my current code:</p>
  
  <pre><code>function uniqueIngredients() {
  
    var book = SpreadsheetApp.getActiveSpreadsheet();
    var r=1;  // starting with row 1 new sheet
    var d='B';
    for (i=1; i&lt;4; i++){  //testing by running 3 iterations
      var m = 'Ingredients!A'+r;  //Intially return Ingredients!A1 then incremented by 11 ex A12
      var c = 'Items!'+d+'4:'+d+'15';  // Initially return Items!B3:B15 then incremented by letter ex Items!C3:C15
      r = r+12;  // add 12 spaces before next copy (max number of ingredients for each item)
      d++;
      book.getRange(c).copyTo(book.getRange(m), {contentsOnly:true});
    }
  };
  </code></pre>