I want change the data row wise to coloum wise & coloumn wise to row wise.

Hi forum,

I have one large worksheet which contains the fields are row wise which I want column wise, and column wise which I want row wise

here I am attaching sample file.

thanx

Copy all data and paste it and transpose it
Copy = Ctrl+C
Paste = Alt + e + s + e + v

This will transpose your data from columns to rows and vice versa

sorry for broken english

thanx dinesh it works perfect.