HSTACK Function

Description

Merge selected arrays horizontally and sequentially.

NOTE

• Input arrays can be of different sizes or put on different sheets and the size of the result array will be: MAX_r x $\sum _{}$_c
• The expected array should not be too large.
• The default value for added cell is #NA.

Syntax

Copied!=HSTACK(array1, [array2], [array3], ...)
=HSTACK(array1, [array2], [array3], ...)

EXAMPLE

Copied!//𝘤𝘰𝘮𝘣𝘪𝘯𝘦 2 𝘤𝘰𝘭𝘶𝘮𝘯𝘴 𝘈1:𝘈3 𝘢𝘯𝘥 𝘊1:𝘊3
=HSTACK(A1:A3, C1:C3)
//𝘤𝘰𝘮𝘣𝘪𝘯𝘦 𝘤𝘰𝘭𝘶𝘮𝘯𝘴 𝘈1:𝘈3, 𝘳𝘰𝘸𝘴 𝘊1:𝘋1 𝘢𝘯𝘥 𝘢𝘳𝘳𝘢𝘺 3𝘹4
=HSTACK(A1:A3, C1:D1, SEQUENCE(3, 4))
//𝘤𝘰𝘮𝘣𝘪𝘯𝘦 3𝘋 𝘳𝘦𝘧𝘦𝘳𝘦𝘯𝘤𝘦𝘴
=HSTACK(Sheet1:Sheet3!A1:C2)
//𝘤𝘰𝘮𝘣𝘪𝘯𝘦 2 𝘤𝘰𝘭𝘶𝘮𝘯𝘴 𝘈1:𝘈3 𝘢𝘯𝘥 𝘊1:𝘊3
=HSTACK(A1:A3, C1:C3)
//𝘤𝘰𝘮𝘣𝘪𝘯𝘦 𝘤𝘰𝘭𝘶𝘮𝘯𝘴 𝘈1:𝘈3, 𝘳𝘰𝘸𝘴 𝘊1:𝘋1 𝘢𝘯𝘥 𝘢𝘳𝘳𝘢𝘺 3𝘹4
=HSTACK(A1:A3, C1:D1, SEQUENCE(3, 4))
//𝘤𝘰𝘮𝘣𝘪𝘯𝘦 3𝘋 𝘳𝘦𝘧𝘦𝘳𝘦𝘯𝘤𝘦𝘴
=HSTACK(Sheet1:Sheet3!A1:C2)

RELATED