title: split one column to multiple named columns
body: <p>During a recent restore and issue occurred that may or may not have been present before however now that I'm aware of it I have been tasked with coming up with a solution to it.  We generally write data to multiple column names for each row however I've found that all the fields are going to an Overflow column.  Below is an example of what we have.</p>
  
  <p>Columns we should have Data in:</p>
  
  <pre><code>fldDate - fldName    - fldPhoneNumber - fldTransactionID - fldOverflow    
  8/15/13 - John Smith - 1012023344     - 123456789        - Null
  </code></pre>
  
  <p>What we are getting:</p>
  
  <pre><code>fldDate - fldName    - fldPhoneNumber - fldTransactionID - fldOverflow   
  8/15/13 - null       - null           - null             - fldName="John Smith", fldPhoneNumber="1012023344", fldTransactionID="123456789"
  </code></pre>
  
  <p>What i need:</p>
  
  <p>I need to find a way to get the fldOverflow field data back into the correct fields.  Any help would be greatly appreciated.</p>