How to convert Multiple columns into single column or array. Use TOCOL Function.

some times we need to convert multiple columns into one single column or array.

instead of using copy paste option.
now in Excel, we have a TOCOL function to fulfill our needs.

Syntax

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

The TOCOL function syntax has the following arguments:

array The array or reference to return as a column.

ignore Whether to ignore certain types of values. By default, no values are ignored. Specify one of the following:

◾ 0 Keep all values (default)
◾ 1 Ignore blanks
◾ 2 Ignore errors
◾ 3 Ignore blanks and errors

scan_by_column Scan the array by column. By default, the array is scanned by row. Scanning determines whether the values are ordered by row or by column.

Remarks

If scan_by_column is omitted or FALSE, the array is scanned by row; If TRUE, the array is scanned by column.