Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/myscript/public_html/classes/classdb.php on line 42
TRANSPOSE Function / Formula in Microsoft Excel 2007 | Video Tutorial

TRANSPOSE Function

TRANSPOSE(), is a Lookup and Reference function assists in converting the vertical cell series as horizontal cell series. It relocates the values available in horizontal and vertical cells.

Formula:


=TRANSPOSE (array)
In above syntax, "array" denotes the series of cells which the user wants to switch over that is, transpose.

Video Tutorial:


Let us view how the TRANSPOSE function can able to reverse the vertical cell series as horizontal cell series with the help of below video.

Learn MS Excel


Ask Questions

Ask Question