in reply to splitting one column into two

If this was a task you were doing by hand (rather than by computer), what would you do?

If you can't state the solution in simple English, you can't program a solution.