Explanation

TOCOL takes a range/array and converts it into a single column.

Example

Syntax

=TOCOL(array, [ignore], [scan_by_column])

array – The range/array of cells we want to convert into a single column.

[ignore] – Optional, use this to skip certain cells when creating the new column. Here are the options for this argument:

0 – Don’t ignore anything. In such case, the newly created column will contain errors from the original array, as well as blank values (represented as 0’s)

1 – Ignore blank values

2 – Ignore errors

3 – Ignore blank values and errors

[scan_by_column] – Optional, use this to determine the order in which the array is scanned. The default is 0, which means – “scan by row”. If the value is set to 1, Excel will scan by column.

Let’s see an example for each of these arguments. First, let’s have a look at the [ignore] argument:

Cool, right?

Let’s now see the [scan_by_column] argument:

Practice TOCOL

Let’s put our knowledge into practice and practice the TOCOL function. Solve the following exercises!