A Excel HSTACK

Hstack

The Excel HSTACK function combines arrays horizontally into a single array. Each subsequent array is appended to the right of the previous array.

combine ranges or arrays horizontally

Remarks

HSTACK returns the array formed by appending each of the array arguments in a column-wise fashion. The resulting array will be the following dimensions:

Rows The maximum of the row count from each of the array arguments.
Columns The combined count of all the columns from each of the array arguments.

Errors

If an array has fewer rows than the maximum width of the selected arrays, Excel returns a #N/A error in the additional rows. Use HSTACK inside the IFERROR function to replace #N/A with the value of your choice.

Syntax

=HSTACK(array1,[array2],…)

The HSTACK function syntax has the following argument:

array The arrays to append.

Return value

A single combined range or array

Examples

Copy the example data in the following table and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.

Example1

Horizontally appends two simple arrays in sequence so that the results are one array.

Data
A	B	C	AA	BB	CC
D	E	F	DD	EE	FF
Formula
=HSTACK(A2:C3,E2:G3)

Example 2

Horizontally appends three arrays in sequence so that the results are one array of three rows and six columns with a #N/A error to fill in empty array elements.

Data
1	2	A	B	X	Y
3	4	C	D
5	6
Formulas
=HSTACK(A2:B4,C2:D3,E2:F2)

Example 3

Horizontally appends three arrays in sequence so that the results are one array of three rows and six columns with a #N/A error to fill in empty array elements. Because cell F3 is originally blank, a 0 value is added to cell F7.

Data
1	2	A	B	C	#VALUE!
3	4	D	E	F
5	6
Formulas
=HSTACK(A2:B4,C2:D3,E2:F3)