Convert Columns to Rows in Excel with Formulas While you can easily convert an arranged workbook or part of it from rows to columns using the Transpose function, that isn’t the case when the ...

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