Freelancer Instructions - Lead Data Cleaning Task

Your task involves cleaning and consolidating lead data from two CSV files.

Steps:
1. Combine both files into one sheet.
2. Remove duplicate entries (based on Email or Phone).
3. Standardize formatting (e.g., capitalize names, unify phone number format).
4. Categorize leads by Region and Product Interest.
5. Highlight any suspicious or incomplete entries (e.g., missing emails).
6. Deliver a cleaned version as CSV and a summary report (PDF or text).

Naming Convention for Cleaned File:
final_leads_q2_cleaned.csv

Tips:
- Use filters to identify duplicates.
- Use conditional formatting to flag missing data.
- Document any assumptions or actions in a separate tab or note.