They asked me to convert rows to columns… and I only knew PIVOT. I remember staring at my screen, heart pounding. I thought I was ready. I had practiced queries, watched tutorials, even built ...

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.