Index/match/hlookup?

Hey guys,

I'm working on figuring out a formula. In sheet1 have table with a list of products and a bunch of attributes and their corresponding values. However, in column A, the product number is duplicated down the list with each new attribute that is used, and there are shared attributes between different products. In sheet2, i have a table of how I want to transpose that data so that only unique attribute types are going across the top, and product numbers arent duplicated in column A. Also, I want the corresponding data for each attribute to show up in the correct cell. I have attached a spreadsheet with the example tables. Keep in mind, this is a small-scale version of my problem, the real one will be applied to thousands of cells.

I would very much appreciate any help/pointers here.

Thanks

A pivot table without any filled in 'values' will give you unique attribute types and product numbers.
http://www.cpearson.com/excel/pivots.htm

Copy and paste these table headings to get the framework as depicted in your example

Then use
=IFERROR(INDEX(Sheet1!$C$1:$C$20,MATCH($A2&B$2,Sheet1!$A$1:$A$20&Sheet1!$B$1:$B$20,0)),"")

..confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

See attached sheet for example