title: Normalize column with multiline values to single value per cell
body: <p>In Google Spreadsheets, I have a row that looks like the following</p>
  
  <pre><code>A   A1
  B   "b1
       B1"
  C   C1
  </code></pre>
  
  <p>where b1 and B1 are in the same cell, but are on two lines. (You can achieve this by pressing ctrl-enter) How do I convert it to the where each of the items in column two is in their own row such as the following:</p>
  
  <pre><code>A   A1
  B   b1
  B   B1
  C   C1
  </code></pre>
  
  <p>I'm looking to create some sort of function that I can apply enmass to a large spreadsheet and so doing it manually doesn't work.</p>