In LibreOffice Calc, there is a way to "rotate" a spreadsheet so that rows become columns and columns become rows.
Select the cell range that you want to transpose.
Izvēlieties Rediģēt - Izgriezt.
Click the cell that is to be the top left cell in the result.
Izvēlieties Rediģēt - Ielīmēt norādot.
In the dialog, mark Paste all and Transpose.
If you now click OK the columns and rows are transposed.