Summarizing Data To Collect Attributes From Multiple Instances

My company would receive RFQs from potential customers inquiring the availability of different products, and we are trying to summarise these requests to find a trend.

Each product has several attributes, such as descriptions, keywords, manufacturer's code, etc. The RFQs are all different, with each request providing some attributes while missing others. The only reliably uniform attribute is the product number.

I am trying to build a database with the maximum amount of details on each requested product, therefore consolidating the different requests. I already put the source data on the same sheet and sorted the product numbers. I also know how many instances there are for each product number. In other words, my data look like this:

Product number (sorted)
Repeat count
Attribute 1
Attribute 2

111a
2
aaaa

[Code] .........

Note:
1. The product numbers and repeat count are reliable
2. All the attributes are valid, i.e. as long as one can fill a blank I would take it
3. If none of the instances provide a certain attribute, it is acceptable for it to be left blank

And I am trying to turn it into this:

Product number
(sorted)
Repeat count
Attribute 1
Attribute 2

111a
2
aaaa
bbbb

123456
1
abcde

100x
3
123456
wxyz

I already spent a whole day trying to do it with MATCH, OFFSET, VLOOKUP etc to no avail. It seems I would need some kind of VBS with loop and array functionalities that are beyond me.