TRANSPOSE function


Converts data in rows to columns and vice versa.



=TRANSPOSE( array )


required arguments:

array A range of cells.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.