HSTACK

Appends arrays horizontally to create a larger array.

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

Syntax

=HSTACK(Array [; Array_1 [; Array_2;[...]]])

Array: The first array to be returned in a new array.

Array_1; Array_2; ...: (optional) the arrays to append sequentially after the previous array.

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

Example:

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

And the second array as:

	N	O
15	PPP	QQQ
16	RRR	SSS
17	TTT	UUU
18	VVV	WWW
19	XXX	YYY

The formula {=HSTACK(A1:E3;N15:O19)} returns the array below, with data of array N15:O19 on the right of the data of array A1:E3, and extra cells filled with #N/A error:

AAA	BBB	CCC	DDD	EEE	PPP	QQQ
FFF			III	JJJ	RRR	SSS
KKK	LLL	MMM	NNN	OOO	TTT	UUU
#N/A	#N/A	#N/A	#N/A	#N/A	VVV	WWW
#N/A	#N/A	#N/A	#N/A	#N/A	XXX	YYY

Technical information

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.HSTACK