TableToArray Function

TABLETOARRAY() Description

The TABLETOARRAY() function converts values from a table into a data array. Creating both 1-dimensional and 2-dimensional arrays is supported.

This allows you to quickly prepare tabular data for further processing.

Main Characteristics of the TABLETOARRAY Function

Syntax:

=TABLETOARRAY(Range; Extent)

Parameters:

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

Usage Example

The TABLETOARRAY() function is easy to use. You just need to select a table and specify the dimension of the desired array (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 - A range containing a table with values.
• Extent: Array dimension (1).

Example 2

In this example, the following values are used:

• Range: A2:D15 - A range containing a table with values.
• Extent: Array dimension (2).

Download the Extension

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

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