TOROW

TOROW(array [,ignore] [,scan_by_column])

Returns the array transformed into a single row.

array	The array or reference to return as a column.
ignore	(Optional) The number indicating which values to ignore: 0 = Keep all values (default) 1 = Ignore blanks 2 = Ignore errors 3 = Ignore blanks and errors
scan_by_column	(Optional) A logical value indicating how the array will be scanned: False (or 0) = Scanned by Row (default) True (<> 0) = Scanned by Column

REMARKS

* This function was added in Microsoft 365.
* This function can create a Dynamic Array Formula.
* If "ignore" is left blank, then keep all values is used.
* If "scan_by_column" is left blank, then False is used.
* If any of the cells are blank, then they are padded with 0.
* You can use the TOCOL function to return the array transformed into a single column.
* You can use the WRAPCOLS function to return the array transformed into multiple columns.
* You can use the WRAPROWS function to return the array transformed into multiple rows.
* This function was first released in March 2022.
* For the Microsoft documentation refer to support.microsoft.com

	A	B	C	D	E
1	=TOROW(C1:D2) = {1,2,4,5}		1	2	3
2	=TOROW(C1:D2,0) = {1,2,4,5}		4	5	6
3	=TOROW(C1:D2,0,False) = {1,2,4,5}
4	=TOROW(C1:D2,1) = {1,2,4,5}		1	2	3
5	=TOROW(C1:D2,1,True) = {1,4,2,5}		4
6	=TOROW(C4:E5) = {1,2,3,4,0,0}
7	=TOROW(C4:E5,0) = {1,2,3,4,0,0}
8	=TOROW(C4:E5,1) = {1,2,3,4}

1 - What is the range "C1:D2" transformed into a single row.
2 - What is the range "C1:D2" transformed into a single row, keeping all the values.
3 - What is the range "C1:D2" transformed into a single row, keeping all the values and scanning by row.
4 - What is the range "C1:D2" transformed into a single row, ignoring all blanks.
5 - What is the range "C1:D2" transformed into a single row, ignoring all blanks and scanning by column. The order has changed slightly.
6 - What is the range "C4:E5" transformed into a single row
7 - What is the range "C4:E5" transformed into a single row, keeping all the values.
8 - What is the range "C4:E5" transformed into a single row, ignoring all blanks.