How to Convert Rows to Columns in OpenOffice. ... Hidden in Calc's Paste Special option, the Transpose feature enables you to convert data listed across a row, so it appears in a column.