Quote:
Originally Posted by Kathryn39
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.