Skip to Content

HSTACK

Appends arrays horizontally and in sequence to return a larger array

Syntax

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

Parameters

  • array1: Required. The first array to append
  • array2: Optional. Additional arrays to append

Example

=HSTACK(A1:B5, D1:E5)
Returns: ArraySince: Microsoft 365