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