Formualizer Docs
ReferenceFunctionsLookup Functions

TRANSPOSE

TRANSPOSE: Swaps rows and columns in an input range.

Summary

TRANSPOSE returns a spilled array whose shape is the inverse of the source shape.

Remarks

  • Input with shape R x C returns output shape C x R.
  • Empty input returns an empty spill.
  • Errors in source cells are preserved in transposed positions.

Examples

Transpose a row into a column
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
[[10],[20],[30]]
Transpose a 2x2 matrix
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
[[1,3],[2,4]]

FAQ

What happens to errors inside the source array?

TRANSPOSE preserves error values and only changes their position in the output matrix.

Does TRANSPOSE return a scalar for 1x1 inputs?

Yes. After transposition, a 1x1 result collapses to a scalar in this engine.

Runtime metadata

Category

Lookup

Signature

TRANSPOSE(arg1: Range (Range))

Arity

min 1, max 1

Arguments

arg1by-ref

Range · Range

Caps

PURE

Source

crates/formualizer-eval/src/builtins/lookup/dynamic.rs

TAKE

TAKE: Returns a subset from the start or end of rows and optional columns.

UNIQUE

UNIQUE: Returns distinct rows or columns from a range.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat happens to errors inside the source array?Does TRANSPOSE return a scalar for 1x1 inputs?Runtime metadata