🧱 Array Combiner

Goal: Combine two separate ranges into one list.
VSTACK puts them on top of each other. HSTACK puts them side-by-side.

Array 1 (Blue)
A
B
C
D
⬇
Array 2 (Amber)
1
2
3
4
Result Spill Range
(Result will spill here)
Ready...

💻 Formula Structure

=VSTACK(array1, [array2], ...)
  • Action: Appends arrays vertically (Row-wise).
  • Dimensions: Column counts must match or Excel pads with #N/A.
-- Select a function...
...
Final Size:
-

⚠️ Common Pitfalls

🚫 Mismatched Sizes
If you HSTACK a 2-row array with a 3-row array, Excel fills the missing cells with #N/A errors.
💡 Combining Headers
VSTACK is perfect for combining a Header row with a Data range: =VSTACK(A1:C1, A2:C100).