Skip to content
ExcelExcel 2024+

HSTACK function in Excel

Appends arrays horizontally and in sequence to return a larger array

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

HSTACK syntax and parameters

Two arguments, one required.

  • array1arrayRequired
  • array2arrayRepeating

HSTACK examples

Formulas you'll actually reuse.

  1. Customer and Amount side by side, skipping the column between them:

    =HSTACK(A2:A50, C2:C50)

  2. Add a running row number as the first column:

    =HSTACK(SEQUENCE(ROWS(A2:B50)), A2:B50)

HSTACK in Google Sheets

Same name — your formula ports as-is.

Try HSTACK in the playground

Edit the example — nothing to install.

Preloaded with the HSTACK formula from Example 1 — change anything and watch it respond.

Loading the editor…

HSTACK errors

What they mean — and the fixes.

  • #N/A

    The arrays have different heights — HSTACK pads the shorter one with #N/A; wrap the result in IFERROR(…, "") to blank them.

Related functions

More ways Excel gets this done.