Excel transpose via paste
- by David Oneill
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.
How do I transpose this text? Is there a way to get past the unicode dialog box and get to the normal Paste special dialog box (that has the 'transpose' option)?
Or, is there another simple way to transpose cells?
transpose = flip rows and columns IE 1, 2, 3 becomes:
1
2
3