Need help with adjusting/modifying macro to fit my data

Here is the macro vba that inserts a new column on the side and extract the first "expected cost" of each "model" and delete the rest of the rows

Below is the macro vba that I created.

Please Login or Register  to view this content.

How do I make this code to fit my dataset below?

Please Login or Register  to view this content.

Hi Th,

The problem was with the Headers:

Please Login or Register  to view this content.