Alphabetizing one column and having the items in the adjacent column follow the locations of alphabetized column without also being alphabetized.
I work as a simultaneous interpreter. I frequently compile glossaries in excel with 2 columns, A for the word in English and then the adjacent B column with the same word in Spanish. I would like to alphabetize the English column and have the Spanish words follow the new locations of the alphabetized A row without being alphabetized itself (since that would separate the corresponding translations). How would I do this?
Thank you in advance!
from upvoted by jmcgready https://ift.tt/2TiwN7a