Forum Discussion

vcsg.90's avatar
vcsg.90
Copper Contributor
Nov 29, 2017

Ordering rows in excel

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.

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    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

     

     

    • vcsg.90's avatar
      vcsg.90
      Copper Contributor

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

Resources