Sorting is putting up a number of things in a particular fashion as per the selected criteria. Sorting in GOOGLE SHEETS is one of the very basic and frequently used operation.
SORTING IN GOOGLE SHEETS IS THE PROCESS OF ARRANGING THE TEXT OR VALUES SYSTEMATICALLY AS PER THE SELECTED CRITERIA.
But there can be situations when we want our data to be in the original state.
There can be many reasons for that such as
1.We just need to find out any data temporarily and need to come back to the original data.2. There is some mistake and we haven’t kept any copy of the data.
For these options, let us find out the ways with which we can keep a track and come to the original sequence of the data.
** There can be some confusion about the terminology here.
Unsort or reverse sort used here are specifically meant for the situation when we want to get back to the original state.
If you want to REVERSE THE SORT ORDER OF THE DATA.Click here.
If you want to RANDOMIZE YOUR DATA Click here.
WAYS TO REVERSE SORT DATA IN GOOGLE SHEETS
There is no direct option to reverse the sorting of the data in Google Sheets.There are mainly two ways to reverse the sorting.
1. Using the UNDO OPTION.
2. Using the HELPER COLUMN.
REVERSE SORT USING UNDO OPTION
The UNDO OPTION is a life saver in the software or applications as well as in GOOGLE SHEETS if we performed any action which didn’t result in the outcome as per expectation.
This happens many times while working.
In the case of sorting, it can happen when we need to remove all the steps and get the original data. For that, we can use UNDO OPTION.
The button location for UNDO OPTION is shown in the picture below.
STEPS TO USE UNDO OPTION:
- Simply press the UNDO BUTTON as shown in the picture above.
- One press will take you ONE OPERATION BACK.
- We can also use KEYBOARD SHORTCUT CTRL+Z for the same. One press means one step back.
- Click UNDO again and again till we get the original data.
IF, BY MISTAKE, WE REACH THE PREVIOUS STEP OF THE ONE WHERE WE INTENDED TO STOP, WE CAN USE CTRL+Y , OR THE BUTTON NEXT TO UNDO WHICH IS KNOWN AS REDO, TO GO TO THE NEXT STEP.
UNSORT DATA IN GOOGLE SHEETS USING HELPER COLUMN
This step is to be used before we start any kind of SORTING OPERATION on our data.
Let us take a sample data to learn the steps.
The data shown above is the original sequence of the data.
If we want to preserve it, or if we doubt that a situation may occur when we need to recover this data or bring the original data, follow the steps.
STEPS TO UNSORT THE DATA.
- Before, sorting the data, create a helper column and name it anything. For our example we’d call it HELPER COLUMN as shown in the picture below.
- Put the content in the column as the location number starting from 1 up to the last number.
- In the mentioned example, we have 19 items so in our helper column the number goes from 1 to 19. This is the actual initial position of the items.
- Now we are free to sort the items as the way we want. We are free to do any operation [Except the operation which create any change in the helper column ].
Let us sort the table with respect to the Days, followed by the increasing sales.
After the sorting, our data will be something like this.
In the above picture, we applied the sorting on the first column, followed by the decreasing order of sales.
[ Kindly don’t confuse the decreasing sales, as it is sub sorting under the day column, if two or more days are same, it’ll sort the sales in descending order.
TO UNSORT THE DATA
Simply sort the data in the ASCENDING ORDER by the helper column.
It’ll bring back the original sequence of the items as required.
Follow the steps to sort the data as per helper column.
- Select the Table.
- Go to DATA MENU > SORT RANGE
- The above shown dialog box will open.
- Check DATA HAS HEADER NOW, if you have selected the Headers also for the sorting.
- Now the COLUMN HEADER NAMES will replace the SORT BY DROP DOWN options as the column header names.
- Choose SORT BY – HELPER COLUMN and A –> Z to get the ascending order.
- Click Sort.
- The original position of the data will result.