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 

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