I am sorting alphabetically the Primary Field which is a Single line text. It does not work. I have some data for this Primary Field that are duplicates and when I sort it, it should be right next to each other but it’s not.
How can I fix this?
Thanks! I tried playing around with adding a space in the beginning and removing it and that fixed it.
I’ll be careful with copying and pasting data in since this is how it first started.