Merging/Formating Question

[xlsiam]

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,

BEFORE	2017			2016
Andy	500		Andy	800
Eddy	100		Eddy	300
John	1000		John	400
Todd	600		Taylor	1
			Todd	600
AFTER	2017	2016
Andy	500	800
Eddy	100	300
John	1000	400
Taylor	0	1
Todd	600	600

<tbody>
</tbody>

 

[Joe4]

Keep an original copy of your two data sets.
Then copy your two name ranges and post one under the other.
Then sort and use the Remove Duplicates functionality to remove all duplicate names.
Then use VLOOKUP functions to pull the appropriate data from your two lists in the proper columns.
You can use an IFERROR function around it to return 0 for unmatched records, i.e.

=IFERROR(VLOOKUP(...),0)