EXPAND
Expands or pads an array to specified row and column dimensions.
Lookup & ReferenceDynamic Arrays & LAMBDALookup & Matching EssentialsModern Excel Functions
What it does
Resizes an array to a larger size, padding extra cells with a value.
Syntax
EXPAND(array, rows, [columns], [pad_with])
Arguments
array(array) — The source array.rows(number) — New number of rows.columns(number) — New number of columns.pad_with(value) — Value to fill extra cells (default #N/A).
Examples
Pad Array
Expand 2x2 array to 3x3 with 'x'.
FORMULA
=EXPAND(A1:B2, 3, 3, "x")
RESULT
[...; x, x, x]
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | A | B |
| 2 | 1 | 2 |
| 3 | 3 | 4 |