The TRANSPOSE Function
The Transpose function will shift a vertical range of cells to a horizontal range and the reverse. To operate correctly, this function needs to be entered as an array formula in a range that has the same number of rows and columns.
For example, suppose that you wanted to transpose the values in column A so that they appear horizontally on row 1:
To do this, first select the destination cells that you would like the results to be shown in:
Next, you would enter the transpose function into the Formula Bar with the original cell range as the argument – in this case it would be “=TRANSPOSE(A1:A5):
Press Ctrl + Shift + Enter to enter this function as an array formula and the results will be displayed within the selected cells:
