3

How can I flip a column of data vertically in Google Spreadsheet?

E.g. if the column is:

Bob
Alice
Calamari

I want:

Calamari
Alice
Bob
Improve this question
2
  • Are You looking dora a built-in featuare (like a menu or keyboard shortcut) a fórmula, macro or a script? Also please add a brief description of your search/research efforts as is suggested in How to Ask
    – Rubén ♦
    Oct 24, 2019 at 23:19
  • Have you tried any of the solutions offered? Did any work for you? If not we should try finding out why. If yes, as per site guidelines when an answer addresses your question, you should accept it and maybe upvote it so others can benefit as well.
    – marikamitsos
    Oct 25, 2019 at 18:59

2 Answers 2

Reset to default
5

You can use the following formula: 

=SORT(B2:B11,ROW(B2:B11)*N(B2:B11<>""),0)

Functions used:
SORT (Sorts the rows of a given array or range by the values in one or more columns.)
ROW (Returns the row number of a specified cell.)
N (Returns the argument provided as a number.)

Improve this answer
1
  • Excellent slightly more complicated solution that supports filtering out unwanted values (in this case blanks) 🤙, thanks for the function breakdown
    – Keego
    May 4, 2022 at 21:57
3 
=SORT(A1:A3,ROW(A1:A3),FALSE)

You can just use sort row, make it false to descending.

Improve this answer
2
  • Your solution does not take into account empty cells. If you try sorting the whole column A1:A you will end up with cell A1 being on the last row of your sheet (row 1000 or worst)
    – marikamitsos
    Oct 25, 2019 at 18:58
  • Excellent straightforward solution if you know the exact range and don't need filtering 🤙
    – Keego
    May 4, 2022 at 21:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.