HSTACK Function Explained

The HSTACK function in Microsoft Excel combines two or more arrays into one array, horizontally. It takes two or more arrays as arguments and returns a single array that contains all the elements of the original arrays, arranged horizontally.

HSTACK Function Syntax

HSTACK(array1, array2, ...)

  • array1: The first array or range of cells to be stacked.
  • array2: The second array or range of cells to be stacked.
  • : Additional arrays or ranges of cells to be stacked.