ExcelBanter - colomn to row

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - colomn to row (https://www.excelbanter.com/excel-discussion-misc-queries/104258-colomn-row.html)

Robert helou

colomn to row

how can i change the colomn data to a row data

CLR

colomn to row

Highlight the Range in the column, then do Copy and then select a cell to
paste to and do PasteSpecial Transpose

Vaya con Dios
Chuck, CABGx3

"Robert helou" wrote:

how can i change the colomn data to a row data

All times are GMT +1. The time now is 10:03 PM.