RANGETOROW
Converts a range of cells to a row range.
Syntax
RANGETOROW(range)
range - the range, whose content should be transferred to a row of values - Value type: a range with cells of any value type
Remarks
The function returns a row range, containing all rows of range subsequently, from left to right.
The cells have the same value and value type as the according cells of range
Example
Here, the range Wine list range is converted into a row:
Last updated