TOROW

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

Returns the array transformed into a single row.

arrayThe 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

 ABCDE
1=TOROW(C1:D2) = {1,2,4,5} 123
2=TOROW(C1:D2,0) = {1,2,4,5} 456
3=TOROW(C1:D2,0,False) = {1,2,4,5}    
4=TOROW(C1:D2,1) = {1,2,4,5} 123
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.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top