EXPAND

This function expands or pads an array to the specified row and column dimensions.

Syntax

EXPAND(array, rows, [columns], [pad\_with])

The function provides the following arguments.

Argument	Description
array	The array to expand.
rows	The number of rows in the expanded array. If missing, rows will not be expanded.
columns	[Optional] The number of columns in the expanded array. If missing, columns will not be expanded.
pad_with	[Optional] The value with which to pad. The default is #N/A.

The function returns an array, the type of each value in the array depends on the parameter.

If rows aren’t provided or are empty, the default value is the number of rows in the array argument.
If columns aren’t provided or are empty, the default value is the number of columns in the array argument.