TableToArray function

TABLETOARRAY() Description

The TABLETOARRAY() function converts values from a table to an array (1- or 2-dimensional).

Main Features of the TABLETOARRAY Function

Syntax:

=TABLETOARRAY(Range; Extent)

Parameters:

• Range: Range with values.
• Extent: Array dimension (1- or 2-dimensional).

Example Usage

The TABLETOARRAY() function is easy to use. You just need to select the table and specify the dimensions of the desired array (1 or 2-dimensional) and Excel (Calc) will automatically return an array of values:

=TABLETOARRAY(Range; Extent)

Example 1

This example uses the following values:

• Range: A2:D15 - The range from which the table with values is contained.
• Extent: Array dimension (1) .

Example 2

This example uses the following values:

• Range: A2:D15 - The range from which the table with values is contained.
• Extent: Array dimension (2) .

Download extension

You can use the function TABLETOARRAY() by installing the extension YLC Utilities .

After that, this function will be available in all files that are opened in Excel (LibreOffice Calc) .