Google Refine seems a really useful tool to work with messy data, clean it up and rearrange it in the way you need it.

More than once I have to perform tedious manual tasks with messy spreadsheets and I would have loved having this tool to help me.

You can learn more about this tool in the project’s website or by watching the official screencasts below: