Parsing horizontal table in Excel & loading it into a database

Select or download this

Name,   Mon-DD
Monica    104,000
...
Brian     92,000
Madeline  112,0000
Averie    140,0000

Select or download this

 Col E through J

Row 6 Col E   ColF     ColG     ColH   ColI     Col J
...
Row 13 Bonus    4,000    5,000    7,000   2,000    15,000
Row 14 Bonus%    10%      20%     10%     2%       14%

Select or download this

 Name  Total_Salary Salary Salary%  Bonus Bonus%
       Monica
       Meredith
       Brian
       Madeline
       Averie

Select Code to Download