split one column to multiple named columns

split one column to multiple named columns

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.
Columns we should have Data in:
fldDate - fldName - fldPhoneNumber - fldTransactionID - fldOverflow
8/15/13 - John Smith - 1012023344 - 123456789 - Null
What we are getting:
fldDate - fldName - fldPhoneNumber - fldTransactionID - fldOverflow
8/15/13 - null - null - null - fldName="John
Smith", fldPhoneNumber="1012023344", fldTransactionID="123456789"
What i need:
I need to find a way to get the fldOverflow field data back into the
correct fields. Any help would be greatly appreciated.