software

How do I quot;copy / pastequot; 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: www.excelforum.com/member.php...oamp;userid=29035
View this thread: www.excelforum.com/showthread...hreadid=514050select A1 to C1
cntrl C to copy the range
select A2
edit......... paste special.......tick quot;transposequot;--
Greetings from New Zealand
Bill K
quot;Cecilquot; gt; wrote in
message ...
gt;
gt; How do I quot;copy / pastequot; many _columns_ of values to many _rows_? In
gt; other words, how do I take a string of values across a worksheet and
gt; put them in one column? Small example ... Would like to take values in
gt; A1, B1 and C1 and put them in A2, A3, A4. Thanks.
gt;
gt;
gt; --
gt; Cecil
gt; ------------------------------------------------------------------------
gt; Cecil's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29035
gt; View this thread: www.excelforum.com/showthread...hreadid=514050
gt;
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 amp; 2003

quot;Cecilquot; gt; wrote in
message ...
gt;
gt; How do I quot;copy / pastequot; many _columns_ of values to many _rows_? In
gt; other words, how do I take a string of values across a worksheet and
gt; put them in one column? Small example ... Would like to take values in
gt; A1, B1 and C1 and put them in A2, A3, A4. Thanks.
gt;
gt;
gt; --
gt; Cecil
gt; ------------------------------------------------------------------------
gt; Cecil's Profile:
www.excelforum.com/member.php...oamp;userid=29035
gt; View this thread: www.excelforum.com/showthread...hreadid=514050
gt;

Hello Bill, Paul gt;gt;gt; Thanks for the tip. That was quot;too easyquot; ... I
shouldn't have missed that one Regards, Cecil.--
Cecil
------------------------------------------------------------------------
Cecil's Profile: www.excelforum.com/member.php...oamp;userid=29035
View this thread: www.excelforum.com/showthread...hreadid=514050