Spread.NET 17 Formula Reference
Formula Functions / Functions T to Z / VSTACK
In This Topic
    VSTACK
    In This Topic

    The function appends arrays vertically and in sequence to return a larger array.

    Syntax

    =VSTACK(array1,[array2],...)

    Arguments

    The function has the following arguments:

    Argument

    Description

    array

    Refers to the array to append.

    Remarks

    The VSTACK function returns the array formed by appending each of the array arguments in a row-wise fashion. The resulting array will be as follows:

    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.

    Note: The VSTACK 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.