Convert CSV Customer Data to Excel

I have a collection of customer records saved in a series of CSV text files, and I need them consolidated into a single, well-structured Excel workbook. Each record contains three distinct data groups—contact information, purchase history, and demographic details.

Your task is to import every CSV file, map each field to an appropriate column, and deliver a clean spreadsheet that is ready for analysis. Please preserve all data as-is while removing obvious duplicates, correcting any broken line breaks that sometimes appear in the text export, and applying clear column headers so the data is self-explanatory.

Deliverables
• One Excel (.xlsx) file with every customer row fully populated
• A short note outlining any assumptions you made or issues you encountered (e.g., missing values, encoding problems)

I will provide the CSV files immediately after we start; they are uniformly formatted, so a solid grasp of Microsoft Excel (or Power Query) and basic data-cleaning techniques should make this straightforward. Let me know if you need a sample file beforehand.