EXPEND (PQL - xl)
This function expands or pads an array to the specified row and column dimensions
- Library: PQL \ Spreadsheet \ Lookup
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
EXPEND(array, rows, OPTIONAL columns, OPTIONAL pad with)
Function Arguments
Name | Description | Type | Optional |
array | The array to expand | StringOrNumber |
|
rows | The number of rows in the expanded array. If missing, rows will not be expanded | Number |
|
columns | The number of columns in the expanded array. If missing, columns will not be expanded | Number | Y |
pad with | The value with which to pad. The default is #N/A | StringOrNumber | Y |
Comments
This function is the same as the Microsoft Excel 'EXPEND' function - using the same inputs, logic and outputs.