Transpose data in Excel 2007

At times, you might had entered some data in rows and later realize that it should had been entered in columns. You can move the data in the rows to columns and vice versa. This is called transpose. To perform transpose of data, do the following:
1. Select the cells that you need to transpose.
2. On the Home tab, in the Clipboard group, click Copy.

3. Click cell A2 or the cell where you need to have the data.
4. On the Home tab, in the Clipboard group, click the down arrow in the Paste command and click Transpose.

Output: