Merging/Formating Question

xlsiam

New Member
Joined
Jan 30, 2014
Messages
5
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>
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
52,156
Office Version
365
Platform
Windows
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.
Code:
=IFERROR(VLOOKUP(...),0)
 

Watch MrExcel Video

Forum statistics

Threads
1,089,931
Messages
5,411,325
Members
403,362
Latest member
DoubleJay

This Week's Hot Topics

Top