Lesson#157: What is the Excel VSTACK function? | How does VSTACK work in Excel?

Microsoft Excel has introduced some new functions in 2022. One of them is the Excel VSTACK function.

What is the Excel VSTACK function?

Description        Excel VSTACK function vertically and sequentially appends arrays to produce a larger array.

This means if you have more than one array in separate places within a worksheet then with this function you can arrange all arrays in a vertical manner.

What is the Syntax of the Excel VSTACK function?

VSTACK(array1,[array2],…)

How does VSTACK work in Excel?

Now you have known what is the Excel VSTACK function and what is the syntax of this function. Now I shall show you how to use the Excel VSTACK function.

Here I shall show you some examples.

Examples of the Excel VSTACK function

In the above picture, I have shown simple examples of two arrays.

Now I have implemented the VSTACK formula on this sheet.

See both arrays are arranged in a vertical manner.

How can I get Excel VSTACK function?

Currently, VSTACK is available on Excel for Microsoft 365 (Windows), Excel for Microsoft 365 (Mac), and  Excel for the web only.

Join our Telegram channel https://t.me/excelabcd

Here you shall be regularly updated with Excel tips and tricks.