Microsoft Office Tutorials and References
In Depth Information
Working with Functions That Return Arrays
Cells B3 through D10 contain information about departments in a company.
Departments are listed going down Column B. Note that the area of B3
through D10 specifically occupies three columns and eight rows. The header
row is included in the area.
Figure 3-6:
Transposing
data.
Cells B16 through I18 contain the transposed data. It is the same data, but
now it occupies eight columns and three rows. In total number of cells, this is
the same size as the original area. Just as important is that the area is made
up of the same dimensions, just reversed. That is, a 3-by-8 area became an
8-by-3 area. The number of cells remains at 24. However the transposed area
has not been altered to be 6 by 3 or 2 by 12, or any other two dimensions that
cover 24 cells.
Every single cell in the B16:I18 range contains the same formula:
{=TRANSPOSE(B3:D10)}. However, the function was entered only once.
Search JabSto ::




Custom Search