Separating Unique values

**Stevenbossche** · 10-19-2021, 02:16 PM

Hi

I have the following problem. I have a datasheet of +- 65 columns and between 20 en 400 rows pro column.
In attachment an example of 2 columns.
Values in each column are unique but are a combination of several values separated by a ;
I would like to have a new sheet where all unique values are listed anther each other.

If the list would only have the products listed in yellow, sheet 2 would look like example I made manually. Problem is that the file is to big to do manually;-)

Does anyone have an idea on how to solve this happens automatically?

PS: every week i will have such a sheet so I need some form of automatisation...

Schermafbeelding 2021-10-19 om 19.57.26.jpg
Schermafbeelding 2021-10-19 om 19.57.06.jpg

**ranman256** · 10-19-2021, 02:50 PM

Did you try clicking the DATA TAB,
remove duplicates?

**Stevenbossche** · 10-19-2021, 03:00 PM

Yes, all cells are unique and all duplicate cells are filtered out.
A
A;B
A;B;C
A;C

--> All 4 cells are unique but I need as answer
A
B
C

**PietBom** · 10-19-2021, 05:28 PM

This challenge can be solved with some VBA coding.
Do you fancy VBA ?
With VBA you can explode the contents of cells by any separator ( , or ; )
After that you can Remove Duplicates and then sort the list alphabatically
Enclosed an example how it can be done.