Microsoft Office Tutorials and References
In Depth Information
Working with Functions That Return Arrays
Figure 3-10 shows the Paste Special dialog box with the Transpose check box
checked. This will transpose the data. You don’t even have to select the
correct number of rows and columns where the transposed data will land. It just
appears transposed, with the active cell as the corner of the area.
However, when data is transposed with the Paste Special dialog box, the
actual data is copied to the new area. By contrast the TRANSPOSE function
pastes a formula that references the original data — and that is the key point.
When data is changed in the original area, the change is reflected in the new,
transposed area, if the TRANSPOSE function was used.
You can transpose data in two ways. The area filled with the TRANSPOSE
function references the original data and will update as original data is changed.
Using the Paste Special dialog box to transpose data creates values that do
not update when the original data changes.