Returns the array in a single column.
Синтаксис
TOCOL(array, [ignore], [scan_by_column])Аргументы
arrayобязательно
The array or range to return as a column.
ignoreнеобязательно
Determines which types of values to ignore: 0 (keep all), 1 (ignore blanks), 2 (ignore errors), 3 (ignore blanks and errors).
scan_by_columnнеобязательно
If TRUE, scans by column; if FALSE (default), scans by row.
The TOCOL function transforms an array or range into a single column. It allows you to specify whether to ignore blanks or errors, and whether to scan the source data by row or by column.
=TOCOL(A1:B2)→Values in a single columnConverts the 2x2 range A1:B2 into a 4x1 column.
Select the target cell
Click on the cell where you want the single-column array to begin.
Enter the formula
Type =TOCOL( and select the range you wish to flatten, then close the parenthesis.
Yes, TOCOL flattens any array or range into a single column regardless of its original dimensions.