TableToArray Function

TABLETOARRAY() Description

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

Key Features of the TABLETOARRAY Function

Syntax:

=TABLETOARRAY(Range; Extent)

Parameters:

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

Example of Use

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

=TABLETOARRAY(Range; Extent)

Example 1

In this example, the following values are used:

• Range: A2:D15 - Range containing the table with values.
• Extent: Array dimension (1).

Example 2

In this example, the following values are used:

• Range: A2:D15 - Range containing the table with values.
• 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).