I have a report where I need to break a specific range of phrases into single words and stack them removing all duplicates.

It would be a three step process that I'm trying to automate:

1. Break words between spaces
2. Stack everything into a single column on a new sheet
3. Remove duplicates

I'm not a programmer myself, so trying to turn manual operation into automate operation I would:

Step 1: use "texto to column" to break the phrases

Step 2 (stack columns): no idea, I'm lost here

Step 3: use "remove duplicates" to well, remove duplicated data

I can handle the VBA for step 1 and 3, but I have no idea how to make the code automation for step 2. Any ideas how can I accomplish that?

[![enter image description here](https://i.stack.imgur.com/WJexB.png)](https://i.stack.imgur.com/WJexB.png)