I have dozens of lines of text repeated 15ish times each in column A. I'm looking for an easy way to remove the duplicates and organize each string, only once, into column B. I'm pretty sure this is possible without a macro, but the text in column A is generated from a text import and several layers of sorting and other formatting, and I want this duplicate removal process to only be performed when the user wants it to be (via a macro-enabled button). Also, the number of lines in column A is variable, as is how many times any particular line is repeated, depending on the imported text. I'm certainly open to a non-macro method if the user can control when it is run.

My current version of the macro uses several IF statements and multiple loops. It is kinda slow, even after turning off screen updates and other optimizations. Any pros out there have a relatively simple way to do this?