Account
λ Lambdas

Community lambdas.

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

NameSignatureDescriptionTags
PIVOT.CAST (table, rows, cols, value, [agg]) Pivot a long table to wide. agg defaults to SUM. reshape 488
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