Transpose in LibreOffice Calc

Sometimes you may need to transpose the contents of a spreadsheet. Doing this in LibreOffice Calc is easy.

1. First copy the contents you want to transpose.

2. Paste the copied contents back in a different location. Right-click and choose Paste Special. From its dialog, choose Transpose. The pasted contents will be the transpose of the original.

Tried with: LibreOffice 3.6.0.4 and Windows 7 x64