79683364

Date: 2025-06-28 22:26:04
Score: 1.5
Natty:
Report link

To reverse the column order (for any data type), I use:

=LET(ncol, COLUMNS(array),
CHOOSECOLS( array, SEQUENCE(,ncol,ncol,-1)) )

I actually define a function, REVERSE_COLS(array), to do this:

=LAMBDA(array,
LET(ncol, COLUMNS(array),
CHOOSECOLS( array, SEQUENCE(,ncol,ncol,-1)) ))

To reverse the row order, I do the same, but use ROWS and CHOOSEROWS in place of COLUMNS and CHOOSECOLS.

Reasons:
  • No code block (0.5):
  • Low reputation (1):
Posted by: Jerry P