Excel Text Data Cleanup

I have a set of raw text entries that must be transferred into Excel and cleaned up before I can use the file elsewhere. The content is purely text, but it is not yet in a usable shape, so when you enter it you’ll also need to format it.

The main task is to copy-paste (or import) the text, then run a quick de-duplication pass so every record is unique. No other transformations—capitalization changes, special-character stripping, or numeric calculations—are necessary. If you prefer to automate the process, feel free to rely on Excel formulas, Power Query, or a lightweight VBA macro; as long as the final sheet arrives free of duplicate rows, we are good.

Deliverable: a single Excel workbook with the cleaned, de-duplicated text data in one worksheet, ready for immediate use.