Select the cells you want to copy, and click copy, select the first cell you
want to paste to, go to paste special, and down the bottom tick the
'transpose' box, click ok.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.