λ 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.CAST (table, rows, cols, value, [agg])

Pivot a long table to wide. agg defaults to SUM.

★ 488 · @j.kwon

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