StarOffice™ 5.2 Calc Handbook

Transposing Column and Row Information

We already took a quick look at the Paste Special dialog box when we copied cell formatting from one cell to another. The Paste Special dialog box also provides you with the option of transposing column and row information. For example, let's say you set up several column headings for a spreadsheet, but then decide that they should have been row headings. Well, rather than copying them one at a time from a column to a row, you can transpose all the information in the spreadsheet from the columns to the rows (or vice versa).

For example, let's say we want to transpose column headings to row headings. Figure 3.20 shows a set of column headings (Months) and the row headings that will result once we transpose ...