Ordering rows in excel

Copper Contributor

Hi. I have a document of 5,499 rows of text that don't have any type of order, so to be able to work with it more easily (I needed to translate the text) I ordered ir alphabetically. But now the client wants the text in the original order. How can I do this? Thanks.

2 Replies

vcsg.90,

 

if you remember the original order or can produce the original order by some kind of logic then put an enumeration in the next column and sort by this column.

 

a 3
is 2
test 4
This 1

 

This 1
is 2
a 3
test

4

 

 

Yes, I have the original un-edited document. Thank you, I will research this option.