Need help removing duplicate text values, space comma separated, from cells within a colum

Hi there;

I am new to this forum and this is my first post. I am looking for a way to remove duplicate values that are contained within a cell, in an entire column of my workbook. It's breaking a Vlookup I am doing for a project at work. some cells have multiple and different values (which is okay) but there are some that have multiple( same values) that I'd like to reduce to one value.

I have attached a sample of the data i am working with and have highlighted cells that have multiple / same values that I would like reduced to single value.

Appreciate any ideas on this.

My solution would, unfortunately, use a number of helper columns. If that would work for you, I will proceed.

I would be interested in your approach. Hoping there might be a Macro that would solve for this, but those I've see so far do
not appear to work. Can you send me info on your helper column approach and I'll try that first.

Thanks

Yes, you could probably do this with macros, but that would take [me, anyways] more time. Hope this works for you (I hid the offending helper columns).

The solution assumes:

• You have up to five entries per line; and
• Any of the five could repeat, not just the first entry.

Making it work for more than five entries is, of course, possible following the same approach.

It's clunky for sure but appears to work in all cases. I did modify one or two entries as part of the testing ...

Of course, you can aways use this approach, turn the results column into text, and then delete the helper columns. That would essentially get you to where you would be if you used macros.

I forgot to mention that my formulas don't "clean up" after themselves, so you may have duplicate commas and so forth. If that's an issue, let me know.

this is helpful thank you. Can you easily talk me through how to do this? I'd like to learn for future uses.

Thanks

Columns B through F determine the ending positions of each entry.
Column G determines how many items in the list for that line.
Columns H through L determine the length of each item.
Columns M through V compare each combination; a "1" means there's a duplicate.
Columns W through AF eliminate duplicates, in reverse order from Columns M through V. This is done that way because if you started from the left, all the starting/ending positions would change each time and you'd have to keep track. This approach avoids that.

The formulas themselves are relatively straightforward, but if you have additioanl questions, please let me know.