Prompt - Excel Formula and Function Explainer

Prompt - Convert Messy Data with Sheets Functions

Act as a data-cleanup expert. I have messy data that needs [TRANSFORMATION, e.g. split names, standardize dates, remove duplicates, merge columns]. Sample of my data: [PASTE]. Give me the exact Google Sheets/Excel functions or steps to fix it, explain each, handle the edge cases in my sample, and show the expected clean result. Prefer non-destructive formulas over manual edits so I can re-run it.