LinkBack URL
About LinkBacks
Please help transpose this data. I want to have column B be horizantial so that if an Item in column A occurs multiple times it then only represents one row with the items in Column B transposed horizontally.
Please help transpose this data. I want to have column B be horizantial so that if an Item in column A occurs multiple times it then only represents one row with the items in Column B transposed horizontally.
Maybe like this?
AA320 AA325 AA330 AA335 AA345 AA350 AL322-FRE FEUSA320 FEUSA325 FEUSA330 FEUSA335 FEUSA345 FEUSA350 AL322FRE
E1=IFERROR(INDEX($A$2:$A$12,MATCH(0,INDEX(COUNTIF($D$1:D1,$A$2:$A$12),),0)),"")
E2=IFERROR(INDEX($B:$B,MATCH(E$1,$A:$A,0)),"")
both copied across as needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
my apologies...this is how I wanted the final output to look:
Base Alt Index
AA320 FEUSA320
AA325 FEUSA325
AA330 FEUSA330
AA335 FEUSA335
AA345 FEUSA345
AA350 FEUSA350 AR130 AH545HUY
AL322-FRE AL322FRE AL322FRE12 AL322FR88
Also posted this at:
http://www.mrexcel.com/forum/excel-q...ml#post4448061
Try
Please Login or Register to view this content.
thank you sir....I will give it a shot tonight and see how it goes.
solved. thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks