View original (French)

Reverse the data in a column on excel

Solved
pat -  
 morgana -
Hello,

I have data in seconds from t0 to t end of the measurement, and I want to reverse it so that it goes from the end of the measurement in line 1 to t0 in the line of the last measurement.

Thank you for your help.
pat

<co
nfig>Windows XP / Safari 535.2</config>

2 answers

  1.
    danric47 Posted messages 3 Status Member 16
     
    A simpler and faster method is to open a column to the left of the column to be reversed with the same number of rows and fill this column with an ordered series of numbers from 1 to n (n = the number of rows in the columns). We select both columns and in "Home" we expand the "Sort & Filter" menu, choose "Custom Sort...", and sort both columns by the values in the newly created number column to the left of the column to be reversed, also selecting "Largest to Smallest", thus inverting the contents of both columns.
    This is more straightforward and simpler.
    dr47
    18
    1. danric47 Posted messages 3 Status Member 16
       
      Ah, the spelling!
      A simpler and faster method involves opening a column to the left of the column to be reversed with the same number of rows and filling this column with an ordered series of numbers from 1 to n (n = the number of rows in the columns). We select the two columns and in "Home" we pull down the "Sort & Filter" menu, choose "Custom Sort..." and sort the two columns by selecting to do it by the values of the numbers column created to the left of the column to be reversed and also choose "Largest to smallest", the contents of the two columns are reversed.
      It's more straightforward and simpler.
      dr47
      0
    2. morgana
       
      Thank you very much for your solution. It's awesome!
      0