ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Converting a row into a column (https://www.excelbanter.com/new-users-excel/63869-converting-row-into-column.html)

bombayterror

Converting a row into a column
 

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


Barb Reinhardt

Converting a row into a column
 
Copy
Paste Special
Transpose

"bombayterror"
wrote in message
news:bombayterror.21c12n_1136751004.7652@excelforu m-nospam.com...

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

Converting a row into a column
 

it worked. thanks a lot


--
bombayterror
------------------------------------------------------------------------
bombayterror's Profile: http://www.excelforum.com/member.php...o&userid=22855
View this thread: http://www.excelforum.com/showthread...hreadid=499201



All times are GMT +1. The time now is 01:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com