How can I merge/format 2017 and 2016 (BEFORE) together like the example at the bottom(AFTER). The only difference is that Taylor has zero for 2017. Thank you,
<tbody>
BEFORE
2017
2016
Andy
500
Andy
800
Eddy
100
Eddy
300
John
1000
John
400
Todd
600
Taylor
1...