Data Transformation Rules Prompt

Write transformation rules to standardise this data.

Data type: [company names / job titles / phone numbers / countries / addresses]

Sample of inconsistent data:
[PASTE 15-20 examples showing the variation]

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