HSTACK Function in Google Sheets

Horizontally stack multiple ranges into a single range using the HSTACK function.

HSTACK Function

The HSTACK function in Google Sheets stacks multiple ranges horizontally into a single range.

Syntax

HSTACK(range1, [range2, ...])
  • range1: The first range to stack.
  • range2, ...: Additional ranges to include (optional).

Examples

  1. Basic Example

Horizontally stack ranges A1:B2 and D1:E2:

=HSTACK(A1:B2, D1:E2)

Notes

  • All specified ranges are combined side by side.
  • VSTACK: Vertically stack ranges.