VSTACK Function Explained

The VSTACK function in Microsoft Excel combines two or more vertical ranges of cells into one single column. It takes two or more ranges as arguments and returns a single column that contains all the values from the specified ranges. The order of the values in the returned column is determined by the order of the ranges in the arguments.

VSTACK Function Syntax

VSTACK(array1, array2)

  • array1: The first array of values to be stacked.
  • array2: The second array of values to be stacked.