Formualizer Docs
ReferenceFunctionsLookup Functions

TOCOL

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

Summary

Flattens input values into one column, 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 row by 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

Can TOCOL filter blanks and errors?

Yes. Use the ignore argument to drop blanks, errors, or both.

Runtime metadata

Category

Lookup

Signature

TOCOL(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

TAKE

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

TOROW

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

On this page

SummaryRemarksExamplesRelated functionsFAQCan TOCOL filter blanks and errors?Runtime metadata