How to Convert Rows to Columns in OpenOffice. Apache OpenOffice's Calc application contains a handy feature for restructuring spreadsheet tables or data lists.