HSTACK Function

The HSTACK function is one of the lookup and reference functions. It is used to horizontally stack arrays into one array.

Syntax

HSTACK (array1, [array2], ...)

The HSTACK function has the following arguments:

Argument Description
array1/2/n Is used to set the arrays to append.

Notes

Please note that this is an array formula. To learn more, please read the Insert array formulas article.

How to apply the HSTACK function.

Examples

The figure below displays the result returned by the HSTACK function.

HSTACK Function