Home » Questions » Computers [ Ask a new question ]

Excel transpose via paste

Excel transpose via paste

I want to transpose data in Excel. Normally, I cut the cells I need, and use paste special -> transpose. However, sometimes when I do paste special, a box comes up asking me if I want to use unicode text vs normal text.

Asked by: Guest | Views: 22
Total answers/comments: 1
Guest [Entry]

"Alternatively, you can use Excel's Transpose function. For example:

=TRANSPOSE(A1:A3)

Do not forget to drag select cells (for example C1 to E1) which will be the location where the results will be displayed. Then type the above function and press the CTRL+SHIFT+ENTER keys on the keyboard at the same time to enter the function as an array function. Then the formula will be viewed as

{=TRANSPOSE(A1:A3)}

in the formula bar above the worksheet."