Page 233 - Excel 2013 All-in-One For Dummies

Copying and Moving Stuff Around 215
check box in the Paste Special dialog box), is particularly helpful when you have a row of column headings that you want to convert into a column of row headings or when you have a column of row headings that you want to convert into a row of column headings. You can also use this option to pivot an entire table of data so that the data that runs across the rows now runs down the columns, and vice versa.
Figure 3-15 illustrates just such a situation. Here, I selected the produc-
tion schedule table (including the column headings) in the cell range A3:J8, clicked the Copy button on the Home tab of the Ribbon, and then moved the cell cursor to cell A10. After that, I chose the Transpose option from the Paste button’s drop-down menu. Excel’s Live Preview feature then shows how this transposition would appear in the cell range A10:F19 in Figure 3-15.
In the transposed table, the original row headings are now the column head- ings just as the original column headings are now the row headings. Note, too, that in transposing the table, Excel retained the formulas that total the units produced each month, although now they appear in the last column of the table instead of the last row.
Figure 3-15:
Transposing a copy
of the production schedule table so that dates now form the row headings and the part numbers now form the column headings.
Book II Chapter 3
Editing and Proofing Worksheets