TOCOL (PQL - xl)
This function returns the array in a single column
- Library: PQL \ Spreadsheet \ Lookup
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
TOCOL(array, OPTIONAL ignore, OPTIONAL scan by column)
Function Arguments
Name | Description | Type | Optional |
array | The array or reference to return as a column | StringOrNumber |
|
ignore | Whether to ignore certain types of values. By default, no values are ignored | Number | Y |
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 | StringOrNumber | Y |
Comments
This function is the same as the Microsoft Excel 'TOCOL' function - using the same inputs, logic and outputs.