Microsoft Office Tutorials and References
In Depth Information
Using the TRANSPOSE function
3. Type a formula that uses the TRANSPOSE function, with the source range address as its
In this example, the formula is
4. Press Ctrl+Shift+Enter (not just Enter) to create a multicell array formula in all of the selected
Any changes made in the source range also appear in the transposed range.