Some data are messy and column can be a mix of different type of data. For example if you work on an address database, you might have a ZIP code column and a State column. And some ZIP code can be stored in the State Column.
Build over time, the RefinePro knowledge base list tutorials, how to and tips for OpenRefine (formerly Google Refine)