Google Sheet: How to reverse and transpose a row?

Question

Need to reverse and transpose a row in google sheet

like below

Tried below formula but didn't reversed the order. Help me out!

=FILTER(TRANSPOSE(A1:E1),TRANSPOSE(A1:E1)<>"")

Answer 1

=SORT(TRANSPOSE(A1:E1),SEQUENCE(COLUMNS(A1:E1)),)

• SEQUENCE to create a array of sequential numbers
• SORT to sort them in reverse

If you need to check for blanks, use QUERY to filter:

=QUERY(SORT(TRANSPOSE(A1:E1),SEQUENCE(COLUMNS(A1:E1)),),"where Col1 is not null",0)