- Formula Reference
- Contacting Us
- Getting Technical Support
- Formula Overview
-
Formula Functions
- Functions A to C
- Functions D to G
-
Functions H to L
- HARMEAN
- HBARSPARKLINE
- HEX2BIN
- HEX2DEC
- HEX2OCT
- HISTOGRAMSPARKLINE
- HLOOKUP
- HOUR
- HSTACK
- HYPERLINK
- HYPGEOM.DIST
- HYPGEOMDIST
- IF
- IFERROR
- IFNA
- IFS
- IMABS
- IMAGE
- IMAGINARY
- IMARGUMENT
- IMCONJUGATE
- IMCOS
- IMCOSH
- IMCOT
- IMCSC
- IMCSCH
- IMDIV
- IMEXP
- IMLN
- IMLOG10
- IMLOG2
- IMPOWER
- IMPRODUCT
- IMREAL
- IMSEC
- IMSECH
- IMSIN
- IMSINH
- IMSQRT
- IMSUB
- IMSUM
- IMTAN
- INDEX
- INDIRECT
- INFO
- INT
- INTERCEPT
- INTRATE
- IPMT
- IRR
- ISBLANK
- ISERR
- ISERROR
- ISEVEN
- ISFORMULA
- ISLOGICAL
- ISNA
- ISNONTEXT
- ISNUMBER
- ISO.CEILING
- ISODD
- ISOMITTED
- ISOWEEKNUM
- ISPMT
- ISREF
- ISTEXT
- JIS
- KURT
- LAMBDA
- LARGE
- LCM
- LEFT
- LEFTB
- LEN
- LENB
- LET
- LINEST
- LINESPARKLINE
- LN
- LOG
- LOG10
- LOGEST
- LOGINV
- LOGNORM.DIST
- LOGNORM.INV
- LOGNORMDIST
- LOOKUP
- LOWER
- Functions M to Q
- Functions R to S
- Functions T to Z
HSTACK
The function appends arrays horizontally and in sequence to return a larger array.
Syntax
=HSTACK(array1,[array2],...)
Arguments
The function has the following arguments:
Argument | Description |
|---|---|
array | The array to append. |
Remarks
The function returns the array formed by appending each of the array arguments in a column-wise fashion. The resulting array will be as follows:
Rows: The maximum of the row count from each of the array arguments.
Columns: The combined count of all the columns from each of the array arguments.
Data Types
The function returns an array, the type of each value in the array depends on the parameter.
Examples
Version Available
This function is available in product version 16.0 or later.
!type=note
Note: The HSTACK function is only available in Beta Insiders builds of Excel for Office 365 currently. Hence, without the Beta Insiders build you cannot import/export the XLSX using this function from/to Excel.