EXPAND
Description
Expands an array to the specified dimensions. Optionally you can specify a value to place
in the added array cells.
Syntax
EXPAND(
array
, [rows
],
[columns
], [pad_with
])- array: The array to expand.
- rows: The number of rows in the expanded array. If you don't specify the argument, the function doesn't expand the rows.
- columns: The number of columns in the expanded array. If you don't specify the argument, the function doesn't expand the rows.
- pad_with: The value to pad the result with. If you don't specify the argument, the default is #N/A.