In 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
Works