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

Broker Special Offers

Intraday Higher Leverage

Save up to 90% in brokerage and get higher leverage for intraday trades.

Name:Phone:
Email:City:
State:
Are you a day trader?