View Single Post
  #2   Report Post  
Spencer101 Spencer101 is offline
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by Kathryn39 View Post
Hello!

I was wondering if anyone could help me; I have about 200 rows of data, with about 200 values in each row, but I would like to have the information that is in each row, to be in a column instead, just wondering is there a quick way of doing this as opposed to copying and pasting each of them?
All help appreciated!

thank you,

Kathryn
Have a look in the Excel Help for how to use "Paste Special / Transpose".
Should do exactly what you're after.