EXPAND function
Summary
Expands or pads an array to specified row and column dimensions
Syntax
Expand(array, rows, [columns], [pad_with])
The EXPAND function syntax has the following arguments:
• array The array to expand.
• rows The number of rows in the expanded array. If missing, rows will not be expanded.
• columns The number of columns in the expanded array. If missing, columns will not be expanded.
• pad_with The value with which to pad. The default is #N/A.
• array The array to expand.
• rows The number of rows in the expanded array. If missing, rows will not be expanded.
• columns The number of columns in the expanded array. If missing, columns will not be expanded.
• pad_with The value with which to pad. The default is #N/A.
Example
=EXPAND(A2:B3,3,3)