title: How to split a single column values to multiple column values?
body: <p>I have a problem splitting single column values to multiple column values.</p>
  
  <p>For Example:</p>
  
  <pre><code>Name
  ------------
  abcd efgh
  ijk lmn opq
  asd j. asdjja
  asb (asdfas) asd
  asd
  </code></pre>
  
  <p>and I need the output something like this:</p>
  
  <pre><code>first_name             last_name
  ----------------------------------
  abcd                     efgh
  ijk                      opq
  asd                      asdjja
  asb                      asd
  asd                      null
  </code></pre>
  
  <p>The middle name can be omitted (no need for a middle name)  The columns are already created and need to insert the data from that single <code>Name</code> column.</p>