Data Parser

Can someone create a VBA routine which will take data in sheet1 and convert it into sheet2? See attached example. Row 1 in sheet1 will always contain the column headings I need to parse. The data is in row 2 through 1000's. Sheet2 shows the end-state. I can have several hundred headings in the first row of sheet1. On some 2 to n rows, there can be multiple variables with the same field name. The one farthest to the right is the one that needs to be saved, all other similar can be ignored. I'm a VBA novice and this problem is a bit out of my league.

Kind Regards,

Tony