In this article:

Google Sheets Reverse Array (Easiest Way to Use It in 2024)

May 8, 2024

Google Sheets Reverse Array

In Google Sheets, reversing an array means you want to reorder the elements in the array so that the last element becomes the first, the second-to-last becomes the second, and so on. This operation can be useful for data analysis where you might need to flip the order of rows or columns to present data in a more understandable or relevant manner.

Google Sheets does not have a built-in function named REVERSE or similar that directly reverses an array, unlike some programming languages. However, you can achieve the same effect using a combination of functions or scripts. 

How to Reverse an Array in Google Sheets

Follow the steps below to reverse an array in Google Sheets using the ‘SORT’ function. 

1. Prepare Your Dataset in a Single Column

Ensure that your data such as a list of names from Alice to Edward, is in column A, from A1 to A5.

google sheets reverse array

2. Create a Helper Column

In column B, next to your names, create a helper column with numbers in reverse order, from 1 in B2 to 5 in B6.

reverse array google sheets

3. Apply the SORT Function to Reverse the Data Order

In a new column, column C, use the SORT function to reverse your data. Enter the formula =SORT(A2:A6, B2:B6, FALSE) in cell C2. This will sort your names based on the numbers in the helper column in descending order.

google sheets reverse order of array

4. Check Your Data to Confirm It's Reversed

Your names should now appear in reverse order in column C, starting with Edward at the top and ending with Alice at the bottom.

 We hope that you now have a better understanding of how to set up Google Sheets reverse array. If you enjoyed this article, you might also like our article on how to find coefficients of variation in Google Sheets or our article on how to insert Greek letters in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->