LibreOffice Calc – Columns to Rows

libreoffice-logoIn LibreOffice Calc, there is a way to “rotate” a spreadsheet so that rows become columns and columns become rows.

How to convert columns to rows in LibreOffice Calc

1) Select the cell range that you want to transpose

2) Choose Edit -> Cut

3) Click the cell that is to be the top left cell in the result

4) Choose Edit -> Paste Special

5) In the dialog, mark Paste all and Transpose

6) If you now click OK the columns and rows are transposed

Share This Post

Related Articles

One Response to “LibreOffice Calc – Columns to Rows”

  1. Harkanwal says:


Leave a Reply

© 2024 All rights reserved. Site Admin · Entries RSS · Comments RSS