MERGEROWS
Description
Merges rows by placing them one below the other into a new range.
Syntax
MERGEROWS(
range1
, [
range2
], ...)
- range1: The first range.
- range2: The second range.
Example
Formula | Result |
|---|---|
=MERGEROWS({1,2;3,4},{10,20,30;40,50,60}) | 1 2
3 4
10 20 30
40 50 60
|
Notes
- This function creates a new range by combining all the range arguments; it starts with the first range and then adds the second range underneath, left-aligning the new range with the resulting range. This continues for all subsequent ranges. In the resulting range, the number of columns equals the widest range in the input. If a range does not have as many columns as the widest range, those additional columns are filled with null values. The number of rows in the resulting range equals the sum of the rows in all of the ranges. Duplicate rows are not removed.
- This function is intended for use in array formulas.
Related Functions
REMOVEROWS