CODEWITHSUNDEEP
google-sheetstransposearray-formulasgoogle-sheets-querytextjoin
Donald Truss
Donald Truss

Reputation: 11

How do I reverse the order of columns in Google Sheets?

before

Column 1   Column 2   Column 3   Column 4   Column 5   
data        data       data       data        data
data        data       data       data        data
data                   data       data        data
data                   data                   data

after 

Column 5   Column 4   Column 3   Column 2   Column 1   
data        data       data       data        data
data        data       data       data        data
data        data       data                   data
data                   data                   data

It's got to be simple but I can't find it!

Upvotes: 1

Views: 1791

Answers (1)

player0
player0

Reputation: 1

try:

=ARRAYFORMULA(QUERY({A:E}, "select "&
 TEXTJOIN(",", 1, "Col"&SORT(TRANSPOSE(COLUMN(A:E)), 1, 0)), 0))

0

Upvotes: 2

Related Questions