The function ToCol returns a range of cells as a single column. You can decide scanning by row or by column.
Syntax:
=ToCol(range of cells, select data, scan by row or column)
Range of cells. is the array containing the data wanted to be return as a row.
Select data. define what type of data to ignore, by default no data is ignored.
Scan by row or column. define how to scan the array selected, by default is scan by row.