TOROW

Formulas / TOROW
Transform an array into a single column.
TOROW(array, ignore, scan_by_column=TRUE)
  • array - required - the array or reference to return as a row
  • ignore - required - whether to ignore certain types of values
  • scan_by_column - required - determines whether to scan the array by row or column

Examples

  • =TOROW(A2:D4)

    The TOROW function can be used to sort the values in a range in ascending order. For instance, if you want to sort the values from A2 to D4, you can use the above formula. This will return a single row with all the values sorted in ascending order.

  • =TOROW(A2:D4)

    The TOROW function can also be used to ignore blank values. For instance, if you have some blank cells in the range A2 to D4, you can use the above formula to return a single row with all the non-blank values sorted in ascending order.

  • =TOROW(A2:D4)

    The TOROW function can also be used to ignore errors. For instance, if you have some cells in the range A2 to D4 that contain errors, you can use this formula to return a single row with all the non-error values sorted in ascending order.

Summary

The TOROW function is used to return an array in a single column. It requires an array argument, an ignore argument and a scan_by_column argument. The ignore argument determines whether to ignore certain types of values and the scan_by_column argument determines how the array will be scanned.

  • The TOROW function transforms an array into a single column, scanning either rows or columns depending on the value of the scan_by_column argument.
  • The arguments for the TOROW function are array, ignore, and scan_by_column. The ignore argument is used to control for ignoring blanks and errors.


Frequently Asked Questions

What is the TOROW function?
The TOROW function is a function that returns an array in a single column. It is a function available in Sourcetable and Google Sheets.
What are the arguments for the TOROW function?
The TOROW function has three required arguments:
  • array: The array or reference to use as the row in the result set.
  • ignore: Whether to ignore certain types of values.
  • scan_by_column: Whether to scan the array by column or row.
How do I use the TOROW function?
To use the TOROW function, input the array into the arguments as the first argument, the ignore argument as the second argument, and the scan_by_column argument as the third argument.
What is the result of the TOROW function?
The result of the TOROW function is an array in a single column.

Related Functions

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.