For those of you need to manipulate a messy dataset. Google refine is your gospel. There are quite a few cool features for you to combine data together as well as picking out extremely values. Useful in business project, social science and any other disciplines playing with data. There are tutorial videos in the link below.
As a google geek, I am exciting that google releases fun things once in a while.