ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how entries in a column can be put into a row (https://www.excelbanter.com/excel-programming/332901-how-entries-column-can-put-into-row.html)

AFZAAL

how entries in a column can be put into a row
 
dear all
I have some long data in a column and i want it to put into a row. can i do
this by a command or two with going to cut and past the individual entries???

Vobiscum[_5_]

how entries in a column can be put into a row
 

Hi,

Try with "copy" and "paste special" with transpose check box checked.

Rgds,

Vobiscu

--
Vobiscu
-----------------------------------------------------------------------
Vobiscum's Profile: http://www.msusenet.com/member.php?userid=245
View this thread: http://www.msusenet.com/t-187056699



All times are GMT +1. The time now is 09:23 PM.

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