Excel Customer Data Entry & Cleanup

I have several batches of customer information that must be organised in a single Excel workbook. Each record needs to follow the exact column order: Name, Email, Purchase History. Before anything is saved, I also need the data cleaned—remove duplicates, fix obvious spelling or formatting issues, and run basic validation so every email follows standard syntax and every purchase entry is aligned to the correct customer.

Here’s what I expect delivered:
• One fully populated spreadsheet, neatly formatted and free of duplicates
• A short log of any anomalies you corrected or records you had to flag for clarification

I will supply the raw files (mix of CSV and PDF). You can work with Excel’s built-in tools, formulas, or Power Query—whatever speeds you up while keeping accuracy high. When finished, the workbook should be ready for immediate analysis, with no additional touch-ups required on my end.