Theignoreargument controls what values TOROW will optionally ignore.
By default,scan_by_columnis FALSE and TOROW will read values “by row” from left to right.
To read values instead by column, setscan_by_columnto TRUE or 1.
Use the TOROW function to transform an array into a singlerowand theTOCOL functionto transform an array into a singlerow.
Note: in Excel,arrays map directly to ranges.
To read values instead by column, setscan_by_columnto TRUE or 1.
The worksheet below shows the default “by row” behavior in F4.
By default, TOCOL will scan values by row, but TOCOL can also scan values by column.
The result is a “trimmed” range that only includes data from the used portion of the range.
