Please send the excel file.
On Fri, Jan 28, 2011 at 1:31 PM, vikalp <dostvik...@gmail.com> wrote: > hellow everybody, > kindly help me with the problem i am facing i want to remove > repititive record from folloeing data and get useful data for the > perpose of mailmerge example is given bellow > example data I have > a b c d > 1 x 20 35 > 1 x 25 35 > 1 x 26 145 > 1 x 35 2568 > 2 y 24 85 > 2 y 25 7431 > 2 y 620 556 > 3 z 25 451 > 3 z 25 451 > > data format I require > > a d c1 d1 c2 d2 c3 d3 c4 d4 > 1 x 20 35 25 35 26 145 35 2568 > 2 y 24 85 25 7431 620 556 > 3 z 25 451 25 451 > > knly help me please > > -- > > ---------------------------------------------------------------------------------- > 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 > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- ---------------------------------------------------------------------------------- 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