=REVERSE(A1:A5) -> A5:A1
DEFINE( REVERSE, LAMBDA( range, IF( ISVERTICAL(range), MAKEARRAY( ROWS(range), 1, LAMBDA( row, _col, INDEX( range, DECREMENT( LENGTH(range), DECREMENT(row)), 1))), MAKEARRAY( 1, COLUMNS(range), LAMBDA( _row, col, INDEX( range, 1, DECREMENT( LENGTH(range), DECREMENT(col))))))))
Help us optimize this function