title: Coding to organize data
body: <p>So I have about 2000 entries in a spreadsheet with data about some companies. The data is organized as it follows:</p>
  
  <blockquote>
    <p>Company name: ...<br>Email: .......<br>Phone no: .....<br>Web: ....<br>address: ....<br><br>Company name: ...<br>Email: ...<br>Phone no: ... <br>etc</p>
  </blockquote>
  
  <p>What I want is to write a function that organizez this in another spreadsheet under the columns</p>
  
  <blockquote>
    <p>Company name &nbsp;&nbsp;&nbsp;&nbsp; Email &nbsp;&nbsp;&nbsp;&nbsp; Phone number &nbsp;&nbsp;&nbsp;&nbsp; Web <br> ......... <br> .........</p>
  </blockquote>
  
  <p>I wrote the intro to the function</p>
  
  <pre><code>function OrganizeData()
  {var sheetFrom = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Orginial");
   var sheetTo = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Organized");
  </code></pre>
  
  <p>but then I'm not sure how to write a code that copies text after a certain keyword (email) from one row of a spreadsheet to another column from spreadsheet 2. </p>