Customer Data Excel Organization -- 2

I have a raw customer information dump that needs to be cleaned up and structured in a single Excel workbook. The spreadsheet must include the following fields for each record:

• Name and address
• Email and phone number

Once the data is validated and entered, I want every row assigned to a clear category column that identifies the customer type, so the final sheet can be quickly filtered or reported on. Simple Excel formulas such as CONCAT, TRIM, and basic IF statements should be used where they save time and improve consistency; however, there is no need for advanced macros or VBA.

Accuracy is critical—I will be cross-checking a sample of the finished data before sign-off—so please double-check spellings, spacing, and the integrity of any formulas you add. I’ll provide the raw file, a short key that explains each customer type, and an example of the desired layout. The completed workbook should be returned ready for immediate use, with no blank rows or orphaned columns.

Turnaround: I would like a first draft within 48 hours, with time for one quick round of revisions if needed.