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: