Account
λ Lambdas

Community lambdas.

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

NameSignatureDescriptionTags
PIVOT.MELT (table, id_cols) Unpivot a wide table into a tall one. Keeps id columns, melts everything else into name/value rows. reshape, array 412
BYROW.IF (array, predicate) Filter rows of a 2D array using a row-wise lambda. Equivalent to BYROW + FILTER, but eager. array 87