Combine Product List and Attribute List

Hello Excel Forum,

I'm new to VBA and the forum, but I have a task in Excel that I'm looking for some wisdom about how to approach. I want to take data from a list of products, and data from a list of additional attributes of these products, then combine the data into a table where each discrete product has its own row.

My example below is a simplified version of what I want to do. I hope it helps to understand my question. My real data is much larger and more complex. Does anyone have a good idea about how to approach something like this?

Thank you.
Stasi
Sample.xlsx

example1.png