how
 

select column, copy, select destination cell, go to speacial paste select
"change column and row" and OK. This will change place of row and column.
Is this what are you looking for?


"Saeid" wrote in message
...
hi . How can I chang data that are in a column in rows to columns in one
row.

how
 

you are right.
"Roger Govier" wrote in message
...
Hi
"change column and row"
The option that shows when you choose Paste Special is Transpose

--
Regards

Roger Govier


"Rasoul Khoshravan" wrote in message
...
select column, copy, select destination cell, go to speacial paste select
"change column and row" and OK. This will change place of row and column.
Is this what are you looking for?


"Saeid" wrote in message
...
hi . How can I chang data that are in a column in rows to columns in one
row.

how
 

hi . How can I chang data that are in a column in rows to columns in one
row.

how
 

Hi
"change column and row"
The option that shows when you choose Paste Special is Transpose

--
Regards

Roger Govier


"Rasoul Khoshravan" wrote in message
...
select column, copy, select destination cell, go to speacial paste
select "change column and row" and OK. This will change place of row
and column.
Is this what are you looking for?


"Saeid" wrote in message
...
hi . How can I chang data that are in a column in rows to columns in
one row.