TOROW

Transforms an array or range into a single row.

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

Syntaxe

=TOROW(Array [; Ignore [;By_column]])

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

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.

Jakýkoli z volitelných argumentů lze vynechat. Volitelný argument vyžaduje, aby byly přítomny všechny předchozí oddělovače.

Příklady

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 {=TOROW(A1:E3)} returns the row

AAA

BBB

CCC

DDD

EEE

FFF

III

JJJ

KKK

LLL

MMM

NNN

OOO

The formula {=TOROW(A1:E3;1)} returns the row below without the blank cells.

AAA

BBB

CCC

DDD

EEE

FFF

III

JJJ

KKK

LLL

MMM

NNN

OOO

The formula {=TOROW(A1:E3;1;TRUE())} returns the row below without the blank cells, scanned by columns.

AAA

FFF

KKK

BBB

LLL

CCC

MMM

DDD

III

NNN

EEE

JJJ

OOO

Technické informace

Tato funkce je k dispozici od verze 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.TOROW