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: {
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