- 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