Dear Kaushik, I am having a small doubt pertaining to your solution given for transpose formula. When i look into the sheet, the claim no. 1 shows the Amount of 10, 10, 50 & 20 was been given. But as per your formula, the Amount of 10, 30 & 20 has got transpose to the Claim NO.1. Where as Amount Rs.30 belongs to Claim No.3.
Hope I am not in a wrong understanding of the solution to point out this. Requested you to clarify my doubt, as this may be helpful in my work. Thank you, Regards, Saroj. On Wed, May 18, 2011 at 8:19 PM, NOORAIN ANSARI <noorain.ans...@gmail.com>wrote: > Dear Kaushik, > > see if it help............ > > On Wed, May 18, 2011 at 4:06 PM, KAUSHIK SAVLA <savla.kaus...@gmail.com>wrote: > >> Hi All, >> >> I want to transpose certain data from row to column if meets specific >> criteria: eg >> Whole data is as below: >> Claim No. Amount >> 1 10 >> 2 20 >> 1 30 >> 1 10 >> 2 20 >> >> >> I want as >> >> Claim No. >> 1 10 30 10 >> >> I want transpose to happen if meets criteria that it match the claim >> number, i have 50000 records as such. >> >> I have attached an spreadsheet as example >> >> Please help its urgent. >> >> Regards, >> Kaushik >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 >> > > > > -- > Thanks & regards, > Noorain Ansari > > -- > > ---------------------------------------------------------------------------------- > 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 > -- ---------------------------------------------------------------------------------- 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
