Excel Tips New Formula Torow Transform multiple row array into single row array.

#excelbeginners #exceltips #excelformula #exceltricks #exceltutorial #excel365 #text #excelshortcuts #tutorial #newformula

Torow is similar to Tocol Full video link :    • Excel Tips New Array Formula : Tocol  

To Row formula transforms array into single row,
It has 3 arguments, first is array to transform, second is to ignore blank and errors, third is to scan by column, true scan by column, which is default, false is to scan by row
Here is an example of two list, equal to To Row select the array to transform and hit enter, data in two column transformed into single row
Suppose, if there is an blank cell in the array, it will show as zero, but if, we don't like to have this, then we have use second argument, after selecting the array, comma, enter one and hit enter, now blank cell is ignored, similarly, to ignore errors, type 2, instead of one, to ignore both, blank and errors in the array, type 3, instead of one
If you notice this, data is read column wise, but if it needs to be read row wise, then last argument is used, first select array to transform, then 3 to ignore blank and errors, comma, 1 and hit enter, now it results in row wise data display.