Reverse the data in a column on excel
Solved
pat
-
morgana -
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>
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 réponses
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
This is more straightforward and simpler.
dr47
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