Libreoffice - Calc - How do I convert rows into columns

In Libreoffice spreadsheet, you can copy rows of data and paste them as a single line. This can be done using copy and then do special paste with transpose option. Here is a video showing how to do it.