PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO REVERSE SORT OR UNSORT DATA IN GOOGLE SHEETS

INTRODUCTION

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.

 

 
What if we want to unsort or reverse sort the data.
The reasons can be many.
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 orginal sequence of the data.

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 softwares 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 GO BEFORE THE STEP , 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.

HOW TO REMOVE SORTING FROM GOOGLE SHEETS
DATA SAMPLE FOR EXAMPLE

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 upto the last number.
ADDING A HELPER COLUMN
ADDING A HELPER COLUMN
  • 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.

YOU CAN LEARN SORTING IN GOOGLE SHEETS HERE.

After the sorting, our data will be something like this.

 

TABLE AFTER DIFFERENT SORTINGS
TABLE AFTER DIFFERENT SORTING OPERATIONS

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> 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.

 

 

UNSORTED TABLE FINAL
RESULT- TABLE IN ITS FIRST STATE BEFORE SORTING

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

Share this:

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

  • PICTURES ARE TOO SMALL?? Don’t worry, Click them, and pinch zoom to see them properly. All pictures are in high resolution.
  • KINDLY LIKE OUR FACEBOOK PAGE BY CLICKING HERE  AND IF WE NEED TO IMPROVE, KINDLY SEND US THE FEEDBACK ON [email protected]
  • Didn’t get what you were looking for?? Just put your question in the chat box present in the Right Lower corner. Name and email id [No spamming, just for the answer of your requirement] are needed.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW
%d bloggers like this: