EXPAND
Expands or pads an array to specified row and column dimensions
Syntax
EXPAND(array, rows, [columns], [pad_with])
Parameters
- array: Required. The array to expand
- rows: Required. The number of rows in the expanded array
- columns: Optional. The number of columns in the expanded array
- pad_with: Optional. The value to pad with. Default is #N/A
Example
=EXPAND(A1:B2, 4, 4, 0)