title: Send range from Google spreadsheet as Email (formatting issue)
body: <p>The following code sends out an email for data in columns 2 and 3, however the results in email are not one below another.</p>
  
  <pre><code>Code.gs
  function email() {
  
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var bulk = ss.getSheetByName("Bulk");
    var lastrow = bulk.getLastRow();
  
    var data1 = bulk.getRange(1, 2, lastrow).getValues();
    var data2 = bulk.getRange(1, 3, lastrow).getValues();
  
    var onedata="", twodata="";
  
    for (var i =1; i &lt; data1.length; i++) {
      if (onedata.length) {
                onedata += ", ";
      }
     onedata += data1[i] 
    }
  
    for (var i =1; i &lt; data2.length; i++) {
      if (twodata.length) {
                twodata += ", ";
      }
     twodata += data2[i] 
    }
  
    var report = ""
  
    report += "&lt;tr&gt;&lt;td style='padding:5px'&gt;" + onedata + "&lt;/td&gt;&lt;td style='padding:5px'&gt;" + twodata + "&lt;/td&gt;&lt;/tr&gt;";
  
  
    report ="&lt;table&gt;&lt;tr&gt;&lt;th'&gt;First data&lt;/th&gt;&lt;th&gt;Second data&lt;/th&gt;&lt;/tr&gt;" + report + "&lt;/table&gt;";
  
    MailApp.sendEmail(Session.getActiveUser().getEmail(),
                      "Your report", report, {htmlBody: report});
  
    }
  </code></pre>
  
  <p>Results received in email</p>
  
  <pre><code>First data                  Second data
  Apple, Orange, Grapes,      Red, Orange, Green, Yellow,
  Banana, Chickoo             Grey
  </code></pre>
  
  <p>Result expected</p>
  
  <pre><code>First data  Second data
  Apple       Red
  Orange      Orange
  Grapes      Green
  Banana      Yellow
  Chickoo     Grey
  </code></pre>