Fix messy date formats or whitespace in seconds.
See results immediately after every change. 40+ Transformations: Filter, join, dedupe, pivot, and more. Easy Data Transform for Mac Free Download
Save your workflow and run it again on new data next week. If you'd like to tailor this post further, let me know: Fix messy date formats or whitespace in seconds