Code Yarns ‍👨‍💻
Tech BlogPersonal Blog

Transpose in LibreOffice Calc

📅 2012-Oct-02 ⬩ ✍️ Ashwin Nanjappa ⬩ 🏷️ libreoffice calc, transpose ⬩ 📚 Archive

Transpose in LibreOffice Calc
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