Hi , You just copy on range a1:a4 and click on other blank cell then right click and select paste special , select value and transpose it can arrange series as you want.
pls note that it can not paste on cell a1 because it was same cell that be copied. Hope it can help you. Worawat 2010/4/28 balbirkumar . <balbirku...@sify.com> > 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 > -- Moo Moo' MyBlog http://ExcelBeginner.BlogSpot.Com >>> Excel Tip http://MySTTAtrtip.BlogSpot.Com >>>My trip picture -- ---------------------------------------------------------------------------------- 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
