Microsoft Office Tutorials and References
In Depth Information
Working with Functions That Return Arrays
3. Enter =TRANSPOSE( to start the function.
Because the receiving area is already selected, the entry will go into the
first cell of the area.
4. Click the first cell in the original data and drag the pointer over the
entire original data area while keeping the mouse button down. Once
the area is selected, release the mouse button.
The function now shows the range of the original area. Figure 3-8 shows
how the entry should appear at this step.
5. Enter a ).
6. Press Ctrl + Shift + Enter to end the function.
Note: The transposed data does not necessarily take on the formatting of the
original area. You may need to format the area. Figure 3-9 shows the result of
using TRANSPOSE and then formatting the transposed data.
Wait! Isn’t this a waste of time? Excel can easily transpose data using the
Paste Special dialog box. Simply copying a range of data and using this dialog
box to paste the data gives the same result as the TRANSPOSE function. Or