Vertically Reverse a Range

The SORT function is used to sort a range based on one of the columns in the range.

This function will be used here to vertically reverse a range even when there is no "sorting helper column".

Example of Use

The objective here is to display the same table on the right but with a vertical inversion:

google sheets range invert vertically

For a column to assist in sorting, it must already be sorted in either ascending or descending order (for example, a column with numbering) to then be sorted in the opposite direction.

In this example, the dates are all unique and in ascending order, so this column can be used as a sorting column.

Simply use the SORT function to perform a descending sort based on this column:

=SORT(A2:B15,A2:A15,0)

google sheets range vertically inverted sort invert

Example of Use Without a Sorting Helper Column

There is not always a usable column to perform an inverse sort (and it is rarely desirable to have to add a new column to the table):

google sheets table invert range vertically

In this case, enter the ROW function (with any of the columns in the range as an argument) to sort based on the row number:

=SORT(A2:B15,ROW(A2:A15),0)

google sheets range vertically inverted sort row invert

If needed, you can copy the Google Sheets document (or view the document) with this example.