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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks