Cleaning lists should be autonomous, not monotonous.
This example uses the following transforms to clean and process a list of emails:
–The Remove duplicate rows step removes or combines rows with a duplicate value (i.e. email address).
–The Split names step splits a name field into its constituent parts, i.e. first, middle, last, etc.
–If you want to get fancy, you can use the Find and replace step to make sure the email addresses are formatted correctly. In the provided example, we use regular expressions (regex) to make sure the email addresses are correctly formatted and remove ones that aren't.