Formualizer Docs
ReferenceFunctionsLookup Functions

TOROW

TOROW: Converts an array or range into a single row.

Summary

Flattens input values into one row, with options to ignore blanks/errors and to scan by row or by column.

Remarks

  • ignore values are 0 keep all, 1 ignore blanks, 2 ignore errors, 3 ignore both.
  • scan_by_column defaults to FALSE, so values are read row by row.

Examples

Flatten to row
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
[[1,2,3,4]]
Scan by column
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
[[1,3,2,4]]

FAQ

Does TOROW preserve row order by default?

Yes. The default scan order is row-major.

Runtime metadata

Category

Lookup

Signature

TOROW(arg1: Range | Any (Range), arg2?: Number, arg3?…: Logical | Number)

Arity

min 1, max variadic

Arguments

arg1

Range | Any · Range

arg2optionaldefault

Number · Scalar · coercion NumberLenientText

arg3optionaldefault

Logical | Number · Scalar

Caps

PURE

Source

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

TOCOL

TOCOL: Converts an array or range into a single column.

TRANSPOSE

TRANSPOSE: Swaps rows and columns in an input range.

On this page

SummaryRemarksExamplesRelated functionsFAQDoes TOROW preserve row order by default?Runtime metadata