I have a spreadsheet containing roughly 2,500 rows where the entire mailing address currently sits in a single cell. Your task is to take that column and cleanly break each record into the following dedicated fields: • Address 1 • Address 2 • Address 3 • City • County • Country • Postcode Because the source data uses mixed delimiters—commas, line breaks, an occasional extra space—formula-only solutions rarely catch everything. I’m therefore fine if you use a mix of Excel functions, Power Query, VBA, or even an external script (Python/pandas, etc.) as long as the end result lands back in Excel and each component sits in its own column with consistent casing and no trailing punctuation. Before final delivery please spot-check for obvious anomalies (e.g., missing postcodes or shifted columns) so I receive a ready-to-use, fully organised file. I’ll share the workbook immediately on award; you simply return a cleaned .xlsx. If anything in the raw data looks ambiguous, flag it in a separate sheet so I can review.