Dear Amit, If you want to just convert data into vertical form. Follow these steps:
-Copy your data using Ctrl+C -Choose the cell where you want to paste your data -Go to the Edit Menu and choose "Paste Special" -In the paste special dialog box choose "All" and click the "Transpose" option...and then click ok. Your data has been transposed from horizontal to vertical. On Sep 26, 11:10 am, NOORAIN ANSARI <noorain.ans...@gmail.com> wrote: > Dear Amit, > > Please see attached sheet.. > > and use > *=INDEX($B$4:$B$150,SMALL(IF($D$4:$D$150=1,ROW($B$4:$B$150),""),ROW(A3))-3) > =Offset($B$4,SMALL(IF($D$4:$D$150=1,ROW($B$4:$B$150),""),ROW(A3))-3,0)* > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>On > Mon, Sep 26, 2011 at 10:33 AM, Amit Gandhi <silkyro...@gmail.com> wrote: > > Thanks alot Noorain > > > It works fine. > > > But I also want to automate Column E i.e. it automatically retrieve Co Name > > as well. If you can help me here as well. > > > Regards > > > Amit > > > On Sat, Sep 24, 2011 at 8:54 PM, NOORAIN ANSARI > > <noorain.ans...@gmail.com>wrote: > > >> Dear Amit, > >> Please see attached sheet, hope it will help to u. > > >> -- > >> Thanks & regards, > >> Noorain Ansari > >> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > >> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > > >> On Sat, Sep 24, 2011 at 5:31 PM, Amit Gandhi <silkyro...@gmail.com>wrote: > > >>> Hi Folks > > >>> I am finding some problem in excel data. I have a excel data (attached > >>> file) in vertical form. I want to convert it into Horizontal form using > >>> Excel Formulas. > > >>> Pls help me here. > > >>> Regards > > >>> Amit > > > -- > > 'Expecting the world to treat u fairly coz u r a good person is like > > expecting the lion not to attack u coz u r a vegetarian. > > Think about it.' > > > Take care > > > Amit > > > > retrieve data(solved).xls > 53KViewDownload -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
