Excel is constantly being updated. TOCOL and TOROW are two new functions.
TOCOL
TOCOL takes the input array (just a fancy name for a group of cells) and puts them all in a column.
TOCOL(array, [ignore], [scan_by_column]).
As you can see, the TOCOL function takes the input cells and stacks them all into one column.
There are also two optional inputs. ignore and scan_by_column.
ignore means you can set it to ignore errors or blank cells, or both.
scan_by_column determines the order of the output. The default value is false which means it will scan by row. As you can see from the example above, the data in the output is in the order of reading across the rows of the input values. Of course, you can always add a SORT function to reorder the data anyway.
TOROW
TOROW does the same as TOCOL, but into a row rather than a column. It has the same two optional inputs.
There is a lot more detail here.