Excel Script to transpose 8000 lines of data into new layout

You will need experience in Excel Scripts & Databases

We have a file of 8000 rows of Products.

Each product has several shared fields, then several unique fields.

I need to transpose the unique fields to a separate row, and copy across the shared fields to fill in the blanks. Example Sheet attached as this may make it easier to explain

There is a mix of some products with 1 row of data, and some with up to 50, with the majority being less than 10.

This is not a manual data entry job, it will need to be a quick programming to script to turn the database into a completed format ASAP.