VSTACK FORMULA TIPS AND TRICKS
🚀Step by step guide 🚀
^Save this video for future reference^.
VSTACK returns the array formed by appending each of the array arguments in a row-wise fashion. The resulting array will be the following dimensions: Rows: the combined count of all the rows from each of the array arguments. Columns: The maximum of the column count from each of the array arguments.
Syntax
=VSTACK(array1,[array2],...)
The VSTACK function syntax has the following argument:
array The arrays to append.
Remarks
VSTACK returns the array formed by appending each of the array arguments in a row-wise fashion. The resulting array will be the following dimensions:
Rows: the combined count of all the rows from each of the array arguments.
Columns: The maximum of the column count from each of the array arguments.
Errors
If an array has fewer columns than the maximum width of the selected arrays, Excel returns a #N/A error in the additional columns. Use VSTACK inside the IFERROR function to replace #N/A with the value of your choice.