Code Yarns ‍👨‍💻
Tech BlogPersonal Blog

Transpose in LibreOffice Calc

📅 2012-Oct-02 ⬩ ✍️ Ashwin Nanjappa ⬩ 📚 Archive

[caption id="attachment_2798" align="aligncenter" width="600"][ ](http://codeyarns.files.wordpress.com/2012/10/20121002-transpose.png) Transpose in LibreOffice Calc[/caption]

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