Removing Duplicates is not removing all duplicates.

[baaaailey]

Hello, I have a single column table that I have appended two tables to create. I then used the 'removed duplicates' option in the column dropdown. However, and this took me forever to find, but for some reason there are STILL 3 sets of duplicate values still in the set after doing this. 

Do anyone know why these wont be removed?

[tackytechtom]

Hi @baaaailey ,

I'll give it a shot. Could it be that there are lagging spaces?

Before:

After remove duplicates:

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[baaaailey]

I dont think so no, I did some trim and then  LEN on both the original and the trimmed version and the number of characters are the same.