um i understand the 1st part of your request just fine...up until:

"with the remaining characters made into a separate record using the same column1/column2"