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.
