The transpose function rotates an array of data. So, changes from data going across a row to down a column and vice versa.
There is also a transpose under paste special, which does the same thing.
In this example, we can see the formula is referencing row B. From B2 to B7. The result of the formula is going across row 2. From D2 to I2. Notice the blue line around the result. This is a formula that spills into multiple cells. The formula itself is only in D2, but the result of the formula takes up multiple cells.
The input for a TRANSPOSE function is very simple. It just requires the array (group of cells) that you want to switch.
=TRANSPOSE(array)
Note that you can input an array that is more than one column wide, as in the example below.
Notice that it is not doing a rotation, where Team 2 would be above Team 1.
A note too about versions. If you have an older version of Excel, then you will need to do things a bit differently. Firstly, you must select all the cells that the data will spill into, and you need to type in the formula, then press CTRL+SHIFT+ENTER.
The other way to transpose data is to use paste special.
If you copy an array (remember just a fancy name for group of cells), then go to where you want to paste them, right click and choose Transpose. It is the under the paste options, and has arrows pointing down and across.
This will do the same thing as the function. Both are useful, depending on your circumstances. Just remember that a function will update if the source data changes, where as a copy and paste is a one-time deal.