TOROW (PQL - xl)
The function returns the array in a single row
- Library: PQL \ Spreadsheet \ Lookup
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
TOROW(array, OPTIONAL ignore, OPTIONAL scan by column)
Function Arguments
Name | Description | Type | Optional |
array | The array or reference to return as a row | 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 'TOROW' function - using the same inputs, logic and outputs.