TRANSPOSE
Changes the orientation of range (array to be precise) from horizontal to vertical or vertical to horizontal
Changes the orientation of range (array to be precise) from horizontal to vertical or vertical to horizontal
Syntax of Excel TRANSPOSE Formula:
=TRANSPOSE(array)
In words:
=Transpose(this array)
There are two important things to understand about TRANSPOSE function:
Must read: 5 Ways to Transpose in Excel – Shifting Columns to Rows or Rows to Columns
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.