The function ToRow returns a range of cells as a single row. You can decide scanning by row or by column.
Syntax:
=ToRow(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, default no data is ignored.
Scan by row or column. define how to scan the array selected, default is by row.