title: Transpose Rows to Columns With a Space
body: <p>I have a spreadsheet with one column and values as follows:</p>
  
  <pre><code>A
  B
  C
  *
  D
  E
  *
  F
  G
  H
  I
  </code></pre>
  
  <p>The <code>*</code> indicates an empty cell. Is there anyway I can get it to read as the following with each one being in a different cell?</p>
  
  <pre><code>1 2 3
  D E
  F G H I
  </code></pre>
  
  <p>I got this <code>=IF(ISBLANK(A12),TRANSPOSE(A13:A23),"")</code> which helps but the range is set to 10. How do set it so it looks for the next empty cell after A13 and backtracks one cell?</p>
  
  <p>Thanks,</p>
  
  <p>JJ</p>