OpenOffice.org Calc: Transpose a Table
Contributed by Rob Rogers 
Tagged: Windows Periodically, you will run into situations where the data you are working with needs to be rearranged in such a manner that the columns of data need to be the rows and the rows need to be the columns. Calc refers to this as Transposing the data. This is quite useful when the main focus of the data has changed from one aspect (the columns) to another (the rows).
1. Select the range of cells containing the data that is to be transposed.
2. Click Edit and select Cut.
3. Select a cell in the spreadsheet that the table will start.
4. Click Edit and select Paste Special.
5. In the Options section, check the Transpose checkbox.
6. Click OK.
You may also like -
Excel 2007: How to Sort Rows
Excel 2007: Eliminate Blank Rows in a Spreadsheet
Creating Databases the Quick, Easy Way With OpenOffice.org
Microsoft Expression Web: Allow Users to Sort Data Displayed in Grid
OpenOffice.org: Change the AutoRecovery Save Interval
Excel 2007: Have Your Data Read Back To You
OpenOffice.org Calc: Print Part of a Spreadsheet
Excel 2007: Clear All Formatting From a Range of Cells
Michael Nissim said on September 27, 2009
Thank you. This was simple and helpful!
Patchouli said on November 8, 2009
Thank you for teaching me how to do this!
Anonymous said on December 16, 2009
cooooool thx