Alphabetizing one column and having the items in the adjacent column follow the locations of alphabetized column without also being alphabetized.

Hello everybody,

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!

submitted by /u/Leviathan5757 to r/excel
[link] [comments]

from upvoted by jmcgready https://ift.tt/2TiwN7a
via IFTTT

Comments

Popular posts from this blog

High density foam rollers for post workout massage

The Polak Game: an exercise to help reveal your theories of the future