is there a method in excel where I can convert a row of entires into a
column
example...
can this --gt;
Population 10 20 30 40 50 60
be converted into this
Population
10
20
30
40
50
60thanks--
bombayterror
------------------------------------------------------------------------
bombayterror's Profile: www.excelforum.com/member.php...oamp;userid=22855
View this thread: www.excelforum.com/showthread...hreadid=499201Copy
Paste Special
Transpose
quot;bombayterrorquot; gt;
wrote in message
news:bombayterror.21c12n_1136751004.7652@excelforu m-nospam.com...
gt;
gt; is there a method in excel where I can convert a row of entires into a
gt; column
gt;
gt; example...
gt; can this --gt;
gt; Population 10 20 30 40 50 60
gt;
gt; be converted into this
gt; Population
gt; 10
gt; 20
gt; 30
gt; 40
gt; 50
gt; 60
gt;
gt;
gt; thanks
gt;
gt;
gt; --
gt; bombayterror
gt; ------------------------------------------------------------------------
gt; bombayterror's Profile:
gt; www.excelforum.com/member.php...oamp;userid=22855
gt; View this thread: www.excelforum.com/showthread...hreadid=499201
gt;
it worked. thanks a lot--
bombayterror
------------------------------------------------------------------------
bombayterror's Profile: www.excelforum.com/member.php...oamp;userid=22855
View this thread: www.excelforum.com/showthread...hreadid=499201
- May 16 Wed 2007 20:37
Converting a row into a column
close
全站熱搜
留言列表
發表留言