Google Sheets-Funktion

TOCOL

Returns the array in a single column.

Formel mit KI erstellen Dieselbe Funktion in Excel

Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.

Syntax

TOCOL(array, [ignore], [scan_by_column])

The TOCOL function transforms an array or range into a single column. It allows you to specify whether to ignore blanks or errors, and whether to scan the source data by row or by column.

Argumente

arrayerforderlichThe array or range to return as a column.
ignoreoptionalDetermines which types of values to ignore: 0 (keep all), 1 (ignore blanks), 2 (ignore errors), 3 (ignore blanks and errors).
scan_by_columnoptionalIf TRUE, scans by column; if FALSE (default), scans by row.

Beispiele

=TOCOL(A1:B2)

Ergebnis: Values in a single column

Converts the 2x2 range A1:B2 into a 4x1 column.

FAQ

Can TOCOL handle multi-dimensional arrays?

Yes, TOCOL flattens any array or range into a single column regardless of its original dimensions.

TOCOL

Syntax

Argumente

Beispiele

FAQ

Verwandte Funktionen

TOCOL

Syntax

Argumente

Beispiele

FAQ

Verwandte Funktionen