is it possible to scan a string and eliminate multiple instances of a word?

Hello all!

How are you all doing today?

I imagine you guys have answered many, many posts on here, however I don't think you've ever run into this kind of situation! I'd like excel to take a string containing a list with commas in between, from a single cell, which may look like this:

"item 1, item 2, item 4, item 1, item 3, item 1, item 4" (the items will not actually say "item" - they have different names)

I'd like excel to eliminate multiple instances of the same item from between the commas and then post them all in one column in a range, one item per cell.

So that would be like this
_ | <--A-->|<--B-->|
1 | item 1 |
2 | item 2 |
3 | item 4 |
4 | item 3 |
5 |

I tried showing a visual representation of it


Thank you for your input!

I've uploaded the excel file with a sample string. Hope this helps!

I never worked with recording what I am doing and it might seem a bit unclear to excel since it doesn't know I'm ignoring multiple instances of the same word when I copy them to a range. Also there will be lots of those strings, each with different items in it and so doing advanced filter would mean I have to do that for each string no?

In your example you eliminated a part of the string from the result. On what basis should that happen in the future?

Yes, if a substring appears more than once it should be deleted when entering all the items in the range format.

I was thinking if we have a function that finds the first word in a string then searches the string for more of those same sub strings and deletes them, then goes to the second word and searches it etc. then the new string is entered as a range in a column.

OR

If we copy the original string in a range in a column and THEN we search for multiples of the same substring and delete them.

I'm not sure which of these ways it's easier or if there is another method? I can't seem to put together a function that can do all this.