VSTACK Function

Description

Merge selected arrays vertically and sequentially.

NOTE

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

Syntax

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

EXAMPLE

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

RELATED