Home

Sort Rows in one column to match the order of the rows in another column

%3CLINGO-SUB%20id%3D%22lingo-sub-132558%22%20slang%3D%22en-US%22%3ESort%20Rows%20in%20one%20column%20to%20match%20the%20order%20of%20the%20rows%20in%20another%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-132558%22%20slang%3D%22en-US%22%3E%3CP%3EI%20had%20a%20document%20with%205%2C500%20rows%20of%20text%20that%20I%20needed%20to%20translated%20but%20it%20was%20completely%20disorganized.%20So%20I%20organized%20the%20rows%20alphabetically%20and%20proceeded%20to%20add%20the%20translation%20next%20to%20the%20text.%20But%20now%20I%20have%20to%20sort%20the%20rows%20back%20to%20the%20original%20order%20that%20I%20was%20given.%20Help%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-132558%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-133509%22%20slang%3D%22en-US%22%3ERe%3A%20Sort%20Rows%20in%20one%20column%20to%20match%20the%20order%20of%20the%20rows%20in%20another%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-133509%22%20slang%3D%22en-US%22%3EDetlef%2C%20I%20didn't%20realise%20that%20the%20question%20I%20replied%20to%20was%20effectively%20a%20duplicate%20of%20the%20one%20you%20answered.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-133507%22%20slang%3D%22en-US%22%3ERe%3A%20Sort%20Rows%20in%20one%20column%20to%20match%20the%20order%20of%20the%20rows%20in%20another%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-133507%22%20slang%3D%22en-US%22%3E%3CP%3EMark%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Elet's%20hope%20that%26nbsp%3B%3CSPAN%3Evcsg.90%20doesn't%20forget%20your%20answer%20as%20quickly%20as%20he%20forgot%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FOrdering-rows-in-excel%2Fm-p%2F132489%23M2966%22%20target%3D%22_blank%22%3Emine%3C%2FA%3E%3C%2FSPAN%3E%3CSPAN%3E.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-133504%22%20slang%3D%22en-US%22%3ERe%3A%20Sort%20Rows%20in%20one%20column%20to%20match%20the%20order%20of%20the%20rows%20in%20another%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-133504%22%20slang%3D%22en-US%22%3E%3CP%3EBefore%20sorting%20your%20data%20alphabetically%2C%20add%20a%20column%20with%20sequential%20number%20values.%26nbsp%3B%20After%20sorting%20alphabetically%20you%20can%20restore%20the%20original%20order%20by%20sorting%20the%20sequential%20number%20column.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
vcsg.90
New Contributor

I had a document with 5,500 rows of text that I needed to translated but it was completely disorganized. So I organized the rows alphabetically and proceeded to add the translation next to the text. But now I have to sort the rows back to the original order that I was given. Help?


3 Replies

Before sorting your data alphabetically, add a column with sequential number values.  After sorting alphabetically you can restore the original order by sorting the sequential number column.

Mark,

 

let's hope that vcsg.90 doesn't forget your answer as quickly as he forgot mine.

Detlef, I didn't realise that the question I replied to was effectively a duplicate of the one you answered.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies