📎 This article includes 1 downloadable practice file ↓
In this article
HSTACK joins arrays horizontally — build a small report from separate results in one formula.
Syntax
=HSTACK(array1, [array2], ...)| Argument | What it means |
|---|---|
array1… |
Arrays to place next to each other. |
Examples
Example 1
=HSTACK(UNIQUE(B2:B500), SUMIFS(E2:E500, B2:B500, UNIQUE(B2:B500)))Each region with its total.
HSTACK in practice
Where you will use it
- Join two tables side by side
- Add a calculated column to a spilled result
- Build report layouts
Worked example
| Case | Formula | Result |
|---|---|---|
| 1 | =ARRAYTOTEXT(CHOOSE(A2,HSTACK({"A";"B"},{1;2}),HSTACK({"x"},{"y"},{"z"}),HSTACK({"A";"B";"C"},{1;2}))) | A, 1, B, 2 |
| 2 | =ARRAYTOTEXT(CHOOSE(A3,HSTACK({"A";"B"},{1;2}),HSTACK({"x"},{"y"},{"z"}),HSTACK({"A";"B";"C"},{1;2}))) | x, y, z |
| 3 | =ARRAYTOTEXT(CHOOSE(A4,HSTACK({"A";"B"},{1;2}),HSTACK({"x"},{"y"},{"z"}),HSTACK({"A";"B";"C"},{1;2}))) | A, 1, B, 2, C, #N/A |
Results calculated in Excel. Row 3 shows the #N/A padding you get when the arrays have different heights.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Different heights | Shorter arrays are padded with #N/A; wrap in IFNA |
| Older Excel | Needs Microsoft 365 |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
⚡ Interactive Practice Lab & Formula Tester:
Test formulas dynamically in our web formula laboratory or download the companion Excel workbook.
📎 Practice files for this article
- 📗Practice workbook: Dynamic arrays18 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.⬇ XLSX · 35 KB
Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong