Home

Ordering rows in excel

Highlighted
vcsg.90
New 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.

Related Conversations
Taking values from certain rows based on data input
Drakerla in Excel on
5 Replies
How to SUM Data from non-regular rows
Andy_Przybysz in Excel on
1 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies