Transpose of data

To take transpose of rectangular data in oocalc

• Select the rectangular region of interest
• Press ctrl-c to copy the data
• Go somewhere where you have sufficient space to paste the transpose. This will be your top-left corner of the new matrix.
• Enter Ctrl-Shift-V to bring up the Paste Special dialog
• Select Transpose in the Options field and press OK
  

tested on oocalc 2.0 on Debian Sid