Many Columns to Many Rows
 

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


--
Cecil
------------------------------------------------------------------------
Cecil's Profile: http://www.excelforum.com/member.php...o&userid=29035
View this thread: http://www.excelforum.com/showthread...hreadid=514050

Many Columns to Many Rows
 

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


--
Greetings from New Zealand
Bill K
"Cecil" wrote in
message ...

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


--
Cecil
------------------------------------------------------------------------
Cecil's Profile:
http://www.excelforum.com/member.php...o&userid=29035
View this thread: http://www.excelforum.com/showthread...hreadid=514050

Many Columns to Many Rows
 

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

"Cecil" wrote in
message ...

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


--
Cecil
------------------------------------------------------------------------
Cecil's Profile:
http://www.excelforum.com/member.php...o&userid=29035
View this thread: http://www.excelforum.com/showthread...hreadid=514050

Many Columns to Many Rows
 

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


--
Cecil
------------------------------------------------------------------------
Cecil's Profile: http://www.excelforum.com/member.php...o&userid=29035
View this thread: http://www.excelforum.com/showthread...hreadid=514050