I have a spreadsheet that has three columns One column contains A, B or C
depending on the product. the other column contains the account number 4
digits and the third column contains the route names.

The account numbers can have an A, B, and / or C next to them depending on
the product they ordered for that day.
I want to sort the A's out and keep the B & C together sorted with their
accounts numbers and their routes

Any help would be greatly appreciatted.

This changes daily.
So I'd like to get a macro or formula or something