datas in excel sheet

#1
Dear All,

I have datas in coloumn format in excel.
like
1
2
3
4
like that,

now i want to change that to row wise like 1,2,3,4 like that..

is it possible? if so how? please tell me.

regards
ganesh
 
#3
Its very simple. All you have to do is select the data--> Copy it--> go to the cell where you want paste--> Right click and select 'Paste Special'--> there select 'Transpose' and click OK
 
#5
very essy.
copy the item like 1,2,3,4.
then click pest special,then click on trasnopose.
it will conver horizental to vertical to other wise.'
regds
ranjan

Dear All,

I have datas in coloumn format in excel.
like
1
2
3
4
like that,

now i want to change that to row wise like 1,2,3,4 like that..

is it possible? if so how? please tell me.

regards
ganesh
 

Similar threads