WRAPROWS (PQL - xl)
The function wraps the provided row or column of values by rows after a specified number of elements to form a new array
- Library: PQL \ Spreadsheet \ Lookup
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
WRAPROWS(vector, wrap count, OPTIONAL pad with)
Function Arguments
Name | Description | Type | Optional |
|---|---|---|---|
vector | The vector or reference to wrap | StringOrNumber |
|
wrap count | The maximum number of values for each row | Number |
|
pad with | The value with which to pad. The default is #N/A | String | Y |
Comments
This function is the same as the Microsoft Excel 'WRAPROWS' function - using the same inputs, logic and outputs.