Excel Core Book
Get our FREE guide on Excel when you subscribe to our free newsletter
Changes the orientation of range (array to be precise) from horizontal to vertical or vertical to horizontal
Syntax of Excel TRANSPOSE Formula:
There are two important things to understand about TRANSPOSE function:
Suppose you have two columns with names and numbers and you want them transposed so that they appear in horizontal formal. All you need to do is to first make the selection that can hold the range then hit F2 key. Once in edit mode type the formula and hit CTRL+SHIFT+ENTER and your data will be transposed.
Remember, you can transpose portion of the data if you want, its not necessary to have the whole range of cells preselected.