You can transpose selected cells in a spreadsheet. Transposing is a way of rotating the cells in a spreadsheet, from horizontal to vertical, with the top row becoming the first column; the second row, the second column; and so on.
Transposing cells in a spreadsheet can be useful when you are including data in a document. For instance, what appears in rows of a spreadsheet might be more appropriately displayed as columns in a report.
To transpose an area of the spreadsheet, select the range of cells you wish to transpose. Then select Cut from the toolbar or the Edit menu, or by right clicking your mouse. You can use the Copy command instead if you wish to keep the original.
Select the range in which you wish to put the transposed values, and then select the Paste Special command from the Edit menu. In the "Paste Special" dialog, click on the checkbox next to Transpose. Click on the Paste button and the spreadsheet will be redrawn with the data transposed.