HSTACK

Appends arrays horizontally to create a larger array.

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

वाक्य संरचना

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

उदाहरणहरू

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