EXPAND
Pads an array to a given size with a fill value.
- Excel: Verified match
- Google Sheets: No equivalent
- Returns: Array
Examples
=EXPAND(A1:B2, 3, 3, "-") | A | B | |
|---|---|---|
| 1 | 10 | 2 |
| 2 | 20 | 4 |
Result 10
Syntax
EXPAND(array, rows, [columns], [pad_with])array- range required
rows- number required
columns- number optional defaults to
3 pad_with- any optional
Errors
#VALUE!=EXPAND(A1:A3,2)
Related
ARRAY_CONSTRAINTruncates a range to at most the given rows and columns. ARRAYFORMULAEvaluates an expression across a range (this engine already spills, so it is a pass-through for sheets compatibility). ARRAYTOTEXTConverts array to text representation. BYCOLApplies lambda to each column of array. BYROWApplies lambda to each row of array. CHOOSECOLSReturns the specified columns from an array.