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
Bookmarks