I want to make reverse order of Column using single formula, How can I make it

Question

I want to make column in reverse order, I tried to do it, but it is taking blank value also. I just want the sheet to check every row and flip the row.

You will understand what I want from this sheet: https://docs.google.com/spreadsheets/d/1WpK3v4fUagbluJev6Oy1BxicH8l9mbjwOrvn4ayZcYQ/edit#gid=0

score 0 · Accepted Answer · answered Oct 16 '19 at 11:38

0

you can do it like this:

=ARRAYFORMULA(TRIM(SPLIT(TRANSPOSE(QUERY(SORT(TRANSPOSE(A2:D3&"♦"), 
 TRANSPOSE(COLUMN(A2:D3)), 0),,999)), "♦")))

answered Oct 16 '19 at 11:38

player0

124,011
12
67
124

I want to make reverse order of Column using single formula, How can I make it

1 Answers1