The Excel Transpose function 'transposes' an array of cells (ie. the function copies a horizontal range of cells into a vertical range and vice versa).
The format of the function is :
Where the array argument is a range of Excel spreadsheet cells.
As the transpose function returns an array of values, it must be entered as an Array Formula.
Transpose Function ExamplesExample 1In the example on the right, the simple vertical range of cells A1A6 is transposed into the horizontal range B1F1. The formula for the function can be seen in the formula bar. The curly braces { } show that the function has been input as an Array Formula. 

Example 2In the spreadsheet on the right, the range of cells A1D2 is transposed into the range F1G4. Again the curly braces { } shown in the formula bar indicate that the function has been input as an Array Formula. 
More examples of the Excel Transpose function are provided on the Microsoft Office website.