I do data work in Emacs all the time and as far as columnar moves go couldn't tell you anything beyond "go look it up on teh Googlez".
Ask me to show you how to transform something in a list of files, though, and yeah I'll show you some shit... ;-)