Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.
I'm lucky that in that I normally work from a data warehouse, so I generally don't have to do this much data cleansing. Therefore I'm sure I didn't come up with the best solution, but I did get there.