Returns the array as a single row.
構文
TOROW(array, [ignore], [scan_by_column])引数
array必須
The array or range to return as a row.
ignore省略可能
Determines which values to ignore: 0 (keep all), 1 (ignore blanks), 2 (ignore errors), 3 (ignore blanks and errors).
scan_by_column省略可能
If TRUE, scans by column; if FALSE (default), scans by row.
The TOROW function transforms an array or range into a single row. It provides options to ignore specific types of values, such as blanks or errors, and allows you to control the scanning order.
=TOROW(A1:B2)→{1, 2, 3, 4}Converts a 2x2 range into a single row.
Select the cell
Click on the cell where you want the result to appear.
Enter the formula
Type =TOROW( and select the range you wish to convert, then close the parenthesis.
Yes, by setting the ignore argument to 1 or 3, you can exclude blank cells from the result.