Converting a row into a column

[bombayterror]

is there a method in excel where I can convert a row of entires into a column

example...
can this -->
Population 10 20 30 40 50 60

be converted into this
Population
10
20
30
40
50
60


thanks

[Barb Reinhardt]

Copy
Paste Special
Transpose

"bombayterror" <[email protected]>
wrote in message
news:[email protected]...
>
> is there a method in excel where I can convert a row of entires into a
> column
>
> example...
> can this -->
> Population 10 20 30 40 50 60
>
> be converted into this
> Population
> 10
> 20
> 30
> 40
> 50
> 60
>
>
> thanks
>
>
> --
> bombayterror
> ------------------------------------------------------------------------
> bombayterror's Profile:
> http://www.excelforum.com/member.php...o&userid=22855
> View this thread: http://www.excelforum.com/showthread...hreadid=499201
>

[bombayterror]

it worked. thanks a lot