Many Columns to Many Rows

C

Cecil

How do I "copy / paste" many _columns_ of values to many _rows_? I
other words, how do I take a string of values across a worksheet an
put them in one column? Small example ... Would like to take values i
A1, B1 and C1 and put them in A2, A3, A4. Thanks
 
B

Bill Kuunders

select A1 to C1
cntrl C to copy the range
select A2
edit......... paste special.......tick "transpose"
 
P

Paul B

Cecil, select your data then Copy, select A2, Paste Special, Transpose.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
C

Cecil

Hello Bill, Paul >>> Thanks for the tip. That was "too easy" ... I
shouldn't have missed that one :cool: Regards, Cecil.
 
Top