Dear Balbir, Copy the column values and in the destination wile pasting give it Paste Special - in paste special choose "Transpose" your task will be done.
Let me know if you still need in detail the steps. This should solve your query On Wed, Apr 28, 2010 at 2:50 PM, balbirkumar . <balbirku...@sify.com> wrote: > Dear Friends, > > > I want to arrange the series of data in a coloum to series of row. For > example > > Data is available in the following Format: > > A > > B > > C > > D > > 1 > > Cat > > > > > > > > 2 > > Rat > > > > > > > > 3 > > Dog > > > > > > > > 4 > > Lion > > > > > > > > 5 > > > > > > > > > > > > > > > > > > > > > > Want to arrange the data as : > > A > > B > > C > > D > > 1 > > Cat > > Rat > > Dog > > Lion > > 2 > > > > > > > > > > 3 > > > > > > > > > > 4 > > > > > > > > > > 5 > > > > > > > > > > > > > > > > > > > > > > Please advice friends. > > > Thanks in Advance. > > -- > Balbir Kumar > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Ahmed Bawazir -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
