Compare two values in different WBs' or sheets' cells and return data

[ETalvitie]

Hello masterminds,
I am doing a large product listing whereas the different products have different properties listed.

I now need to find all listed properties for each product and gather that data to Sheet1.

Please see the attached sample file.
Master data is in Sheet2 (this is where I would search) and Sheet1 where I would like to compile the data to only one product code per row and to to each property's column respectively.
Macro should run as long as there are product codes found in Column C in Sheet1.

No macro-example attached, since I didn't know how to approach this, but I made the wanted result as an example to Sheet1.

Many thanks for this help, as I believe this will be a piece of cake for most, if not all of you guru's here