You got pretty much all the right answers in all the good idioms already. But it sounds to me like you are breaking your data. The placement at least once corresponded to some sort of meaningful column, unless the original dev was a complete jackass. So you will be removing implicit meaning and if there are data anywhere in the mostly empty columns you'll end up sorry about the "cleaning" you're attempting.

Update: s/DERP/you're/