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.