close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()