Lookup & Reference Function - TOCOL

Transpose the data from an array into a column using this brand new Excel function.

The video shows the TOCOL function in use.

The written calculation is below:

=TOCOL(B3:D8)

​Our example transposes the table into one long column of data.