I have 4 columns in this workbook and I'd like to be able to sort a specific column alphabetically and have the contents of the rows switch with them. Does that make sense?

Everything in column A is an item that is unique, column B is the location of those items. I want to sort those items by location, so when I sort B alphabetically, I need A to still correspond.

Any help is appreciated!