Skip to main content

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:

ArgumentDescription
array1/2/nIs 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