title: Google Spreadsheet - Convert multiple columns to one column
body: <p>I want to loop through a set of rows in a Google Spreadsheet that look like this:</p>
  
  <p>XXX  123   234   234</p>
  
  <p>YYY  789   098   765</p>
  
  <p>ZZZ  76    123   345</p>
  
  <h2>End Result Needs to Be:</h2>
  
  <p>XXX: 123</p>
  
  <p>XXX: 234</p>
  
  <p>XXX: 234</p>
  
  <p>YYY: 789</p>
  
  <p>YYY: 098</p>
  
  <p>etc.</p>
  
  <p>My current code:</p>
  
  <pre><code>function loopshoplocations(){ 
    var sheet = SpreadsheetApp.getActiveSheet(); 
    var data = sheet.getRange('A4:A8').getValues(); 
    var i=0; 
    for(i = 0; i &lt; 4; i++){
      return ('Shop Location: ' + data[i][0]);
    }}
  </code></pre>