Transposing Rows and Columns

Transposing rows and columns can come in handy if you discover that your spreadsheet would have worked better if your rows had been columns and your columns had been rows. The Transpose feature lets you switch rows and columns.

Consider the spreadsheet shown in Figure 13.6; it would probably be easier to read if the months appeared down the side as row headings and the items being sold appeared across the top as column headingsand, of course, the appropriate data would appear in the appropriate cell.

Figure 13.6. A spreadsheet that could benefit if the rows and columns were swapped.

When you switch rows and columns, Quattro Pro copies the information you select to a new area of the spreadsheet, switching rows with columns and columns with rows in the process. Make sure that you have enough blank space in the destination area to accommodate the information; otherwise, Quattro Pro will overwrite the contents of the destination area with the transposed data.

To switch the rows and columns, follow these steps:

1.	Select the data you want to transpose; for this example, I selected A3.N7.
2.	Open the Tools menu, point to Numeric Tools, and click Transpose. Quattro Pro displays the Transpose Cells dialog box shown in Figure 13.7. The range you want to transpose appears in the From box. Figure 13.7. Use this dialog box to identify the range containing the data you want to transpose and the range where you want the transposed data to appear. Quattro Pro does not adjust formulas when you transpose rows and columns. Be sure to edit or reenter formulas as necessary.
3.	Click the Range Picker button in the To box; Quattro Pro collapses the Transpose Cells dialog box so that you can work in the spreadsheet (see Figure 13.8). Figure 13.8. Select the upper-left corner of the range where the transposed information should appear.
4.	Click the cell that should become the upper-left corner of the newly transposed range; for this example, I clicked A10.
5.	Click the Maximize button on the title bar of the Transpose Cells dialog box. The Transpose dialog box reappears, displaying the cell you selected in the To box.
6.	Click OK. Quattro Pro swaps the information in the rows and columns and displays the information starting in the cell you selected in the To box (see Figure 13.9). Figure 13.9. The spreadsheet after transposing the rows and columns.