Data Transformation Rules

Write transformation rules to standardise this data.

Data type: {{company_names_job_titles_phone_numbers_c}}

Sample of inconsistent data:
{{paste_15_20_examples_showing_the_variati}}

Desired output format: {{describe_the_clean_version}}
Platform: {{sql_excel_python_zapier_clay_airtable}}

Please:
1. Identify all variation patterns in the sample
2. Write transformation rules to standardise them
3. Provide the logic in plain English
4. Provide code or formula for my platform if applicable
5. Flag edge cases that need manual review

Copied to clipboard.