How to Transform an Array in a Single Column

TOCOL function is used to transform an array into a single column. The TOCOL function lets you rearrange values in 2D cell ranges to a single column. It’s handy for combining data across multiple columns and rows into a single column.

Syntax: TOCOL(array, [ignore], [scan_by_column])

Here, 

·   array : The array or reference to return as a column.

· ignore : [Optional] Use the values listed below to specify whether to ignore certain types of values. By default, no values are ignored.

o    0 : Keep all values (default)

o    1 : Ignore blanks

o    2 : Ignore errors

o    3 : Ignore blanks and errors

·  scan_by_column : [Optional] Scan the array by column. By default, the array is scanned by row. Scanning determines whether the values in the function result are ordered by row or by column.

Suppose you have the following data in cells E1:H6. To convert this data to a single column array, you can use the TOCOL function as follows:

The result will be a dynamic array that consists of the values from the input range, arranged in a single column as shown in the picture.