I have a sheet with a column called Category. This is a drop-down column with options starting with A, B, C, G, L, PL, PP, and S. The items are ordered that way. When I sort the rows using that column, the result is A, C, G, L, PL, PP, S, and B. I have checked for strange characters and the order of the drop-down items and found no mistakes. I have read similar posts and apparently, the issue was the drop-down items' order. This is not the case. Any suggestions?
