HSTACK function

Category: Lookup and reference
Introduced: Excel 2024

Summary

Appends arrays horizontally and in sequence to return a larger array

Syntax

HSTACK(array1,[array2],...) The HSTACK function syntax has the following argument:
array The arrays to append.

Example

=HSTACK(A2:C3,E2:G3)
=HSTACK(A2:B4,C2:D3,E2:F2)
=HSTACK(A2:B4,C2:D3,E2:F3)

Microsoft Support Page

https://support.microsoft.com/en-us/office/hstack-function-98c4ab76-10fe-4b4f-8d5f-af1c125fe8c2

Back to Functions