Clean messy data

Here's a sample of my messy data: [PASTE]. Suggest the cleaning steps (spaces, duplicates, formats, spelling variants) and give instructions for doing them in [TOOL].