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/332903-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. how can i
do this without cutting individual entries and pasting in row

Norman Jones

how entries in a column can be put into a row
 
Hi Afzaal,

Select the cells,
Edit | Copy
Select a cell outside the copy area
Edit | PasteSpecial | select the 'Transpose' option


---
Regards,
Norman



"AFZAAL" wrote in message
...
dear all
i have some long data in a column and i want it to put into a row. how can
i
do this without cutting individual entries and pasting in row





All times are GMT +1. The time now is 11:07 PM.

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