I'm importing the data from another sheet using the import range. How can I flip a column of data vertically in another Google Spreadsheet?
=sort(index(IMPORTRANGE("URL")
E.g. if the column is:
Cat
Dog
Tiger
Mouse
I want:
Mouse
Tiger
Dog
Cat