Microsoft Office Tutorials and References

In Depth Information

Exhibit 4.5
Data transpose cell formula

1. Identify the source data to be transposed (A2:G4): simply know where it is

located and the number of columns and rows it contains.

2. Select and capture a target range where the data transposition will take place—

A11:C17. The target range for transposition must have the same number of

columns
as the source has
rows
and the same number of
rows
as the source

has
columns
—A2:G4 has 3 rows and 7 columns which will be transposed to the

target range A11:C17 which has 7 rows and 3 columns.

3. While the entire target range is captured, enter the
Transpose
formula. It is

imperative that the entire target range remain captured throughout this process.

4. The last step is very important, in that it creates the array format for the tar-

get range. Rather than depressing the
Enter
key to complete the formula entry,

simultaneously depress
Ctrl-Shift-Enter
, in that order of key strokes.

5. Interestingly, the formula in the target range will be the same for all cells in the

range:
{

TRANSPOSE(A2:G4)}

6. The brackets ({}) surrounding the formula, sometimes called curly brackets,

designate the range as an array. The only way to create an array is to use the
Ctrl-

Shift-Enter
sequence of key strokes (the brackets are automatically produced).

Note that physically typing the brackets will not create an array in the range.

=

Search JabSto ::

Custom Search