title: how to split one column into two columns base on conditions in EXCEL
body: <p>I am very new to Excel. Please help</p>
  
  <pre><code>Column1
  A,1
  B,2
  C,1
  D,2
  E,1
  </code></pre>
  
  <p>output:</p>
  
  <pre><code>Column2  Column3
  A,1       B,2
  C,1       D,2
  E,1
  </code></pre>
  
  <p>what is the formula to do this? Thanks!</p>