Microsoft Office Tutorials and References
In Depth Information
Using the TRANSPOSE Function to Formulaically Turn Data
rizontally, and other people build their worksheets vertically. For ex-
ample, in Figure 12.42 , the monthly totals stretch horizontally across row
80. However, for some reason, you need these figures to be arranged going ver-
tically down from cell B84.
Figure 12.42. One
TRANSPOSE function occupies 12 cells, from B84:B95.
function occupies 12 cells, from B84:B95.
The typical method is to copy C80:N80 and then use Home, Paste, Transpose.
This copies a snapshot of the totals in row 80 to a column of data.
This is fine if you only need a snapshot of the totals. However, what if you
want to see the totals continually updated in column B? Excel provides the
TRANSPOSE function for such situations.
Because the function returns several answers, you need to use special care
when entering the formula. Here ’ s how:
11. Note that C80:N80 contains 12 cells.
22. Select an identical number of cells starting in B84. Select B84:B95.
33. Even though you have 12 cells selected, type the formula
=TRANSPOSE(C80:N80) as if you had only one cell selected.