RANGETOROW
Converts a range of cells to a row range.
Converts a range of cells to a row range.
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
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
Here, the range Wine list range is converted into a row: