*Array Formula, written in 9 cells (oneRow Range) at once !* =IFERROR(TRANSPOSE(INDEX($B$3:$B$11,SMALL(IF($A$3:$A$11=$C16,ROW($1:$9)),ROW($1:$9)))),"")
On Wed, May 18, 2011 at 5:36 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
ctv_Conditional_Transpose.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
