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
|
Definitively you can copy from row and paste special to column but there are other methods around.
You can try recording a micro to do your job. On the other hand you can use OFFSET formula to do your job.
You can also visit
http://www.techyv.com/questions/simp...ow-data-column for more information.
I hope this would be of some help.
Similar Threads
Hybrid Mode
