TOCOL

Transforms an array or range into a single column.

Enter the formula as an array formula. Hint: enter formula using keys Ctrl + Shift + Enter.

Sintaxia

TOCOL(Array [; Ignore [; By_column]])

Array: the array or range to return as a single column.

Ignore: (optional) Whether to ignore certain types of values. By default, no values are ignored. Specify one of the following:

0: Keep all values (default)

1: Ignore blank cells

2: Ignore cells with errors

3: Ignore both blank cells and error cells

By_column: (optional) Scan the array by column. By default, the array is scanned by row. Scanning determines whether the values are ordered by row or by column.

Any of the optional arguments can be omitted. An optional argument requires all preceding separators to be present.

Adibideak

Consider the array A1:E3 below:

	A	B	C	D	E
1	AAA	BBB	CCC	DDD	EEE
2	FFF			III	JJJ
3	KKK	LLL	MMM	NNN	OOO

The formula {=TOCOL(A1:E3)} returns the column

AAA

BBB

CCC

DDD

EEE

FFF

III

JJJ

KKK

LLL

MMM

NNN

OOO

The formula =TOCOL(A1:E3;1) returns the column below without the blank cells.

AAA

BBB

CCC

DDD

EEE

FFF

III

JJJ

KKK

LLL

MMM

NNN

OOO

The formula =TOCOL(A1:E3;1;TRUE()) returns the column below without the blank cells, scanned by columns.

AAA

FFF

KKK

BBB

LLL

CCC

MMM

DDD

III

NNN

EEE

JJJ

OOO

Informazio teknikoa

This function is available since LibreOffice 25.8.

This function is NOT part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.TOCOL