λ Lambdas

Community lambdas.

Copyable definitions. Tested. Tagged. Star the ones you use.

All 12 array 2 text 3 date 1 finance 2 reshape 2 stats 4 geo 1 simulation 1Table

PIVOT.MELT (table, id_cols)

Unpivot a wide table into a tall one. Keeps id columns, melts everything else into name/value rows.

★ 412 · @a.morton

BYROW.IF (array, predicate)

Filter rows of a 2D array using a row-wise lambda. Equivalent to BYROW + FILTER, but eager.

★ 87 · @d.howe