clean up messy data