Array Transformation functions

AFLIP

Reference

» Reference, Discussion, & Example Applications:

About

Flips an array.

Inputs:

  • a : the array
  • [f] : flip argument: 0 or omitted, flips horizontal; 1, flips vertical; 2, flips horizonal and vertical

Code

M.S. Excel 
AFLIP = LAMBDA(a, [f],
    LET(
        r, ROWS(a),
        c, COLUMNS(a),
        sr, SEQUENCE(r),
        sc, SEQUENCE(, c),
        x, IF(f, r - sr + 1, sr),
        y, IF(f = 1, sc, c - sc + 1),
        INDEX(IF(a = "", "", a), x, y)
    )
);