Your table sounds like it's straight out of a "how not to design a database 101" textbook. Having everything in one loooooooong row is tedious (for exactly the sort of trouble you're having -- interfacing with sensible, multi-row tables is a pain, not to mention having to write super-long queries to get anything done) and hard to maintain (although I guess futureproofing isn't much of an issue here...).
If you had multiple tables that mirrored the originals (with perhaps some extra columns) you could use the "
INSERT INTO SELECT" syntax to copy back and forth directly.