TOROW function - Zoho Sheet - Help Guide

TOROW

Transforms a given array into a single row.
 
Syntax
 
TOROW(array; [ignore]; [direction])
array: The range of cells containing the values to transform. Eg., A2:C3
ignore: Specifies the values to ignore in the given array. Defaults to 0 if omitted.
0 - Keep all values.
1 - Ignore blank cells
2 - Ignore errors
3 - Ignore blank cells and errors
direction: Specifies how the given array must be read. If TRUE, the array will be scanned by column. If FALSE or omitted, the array will be scanned by row.
 
Examples
 
Formula
=TOROW(A2:C3;1)
=TOROW(A6:C8;1;TRUE)

Get a hands-on experience of the function in the embedded range below. 

 

Possible Errors
 
Errors
Meaning
#NAME!
  • The function name is incorrect or invalid.
  • The given defined name (if any) is invalid.
  • There is a typo in the defined name used in the function.
  • Double quotes are missing for text values in the function.
  • Colon missing in a cell range reference.
#VALUE!
  • The given argument's data type is incorrect or invalid.
    For example, the function =DATE(A1:A3) will return a #VALUE error when a text value is present in the range.
#REF!
  • The given cell reference is incorrect or invalid. This error may occur when a cell/range has been deleted, moved, or pasted over.
#NUM!
  • The given array is too large.
 
Similar Functions
  1. TOCOL