Appends arrays vertically to return a single combined array.
Syntax
VSTACK(array1, [array2], ...)Argumente
array1erforderlich
The first array to append.
array2optional
Additional arrays to append.
The VSTACK function combines multiple ranges or arrays into one single vertical array. It automatically stacks the second array below the first, the third below the second, and so on, maintaining the original column structure.
=VSTACK({1;2}, {3;4})→{1;2;3;4}Combines two vertical arrays into one column of four rows.
Select the target cell
Click on the cell where you want the combined data to appear.
Enter the formula
Type =VSTACK( followed by the ranges or arrays you wish to combine, separated by commas.
Press Enter
The function will spill the results into the adjacent cells automatically.
VSTACK will return a #N/A error for the empty cells created by the mismatch.