Reconfiguring spreadsheet data for inputting to ecommerce site

I have two sets of data (one of which is attached here)
There are two brands, Mascot and Portwest. From the supplied data I need it reorganised into a new format for importing into an ecommerce platform. In each folder you will find a source spreadsheet, an example of how the data should look once put into the new format, and most importantly a 'rosetta stone' file that says what should be placed where.

This needs to be done as soon as possible to produce a single table for each brand.

Take careful note that each set of options for a product are on separate rows to the main product data.
Please let me know a cost and a timeframe. Thank you.