Currently trying to sort data into alphabetical order, however, I am running into a problem.
Every time I try to sort it the product number doesn't match up with the product.
I have been going on for hours trying to figure this out, but I can't seem to lock the "columns" that have multiple sub-columns to it. It seems as if it is only sorting on a 1 by 1 basis. How would I sort it with multiple columns? For an example the supply "Herculite xRV composite" has multiple product numbers but when sorted the numbers just get placed at the bottom and only the cell next to the product name follows it when sorting.