Help needed! Partially duplicated country list in two columns with different corresponding values

[EmmaMeowMeow]

Dear excel community friends,

I have a situation that I am using two systems to send out text requests, and 2 systems handle different countries (very similar but not exactly the same), and they have different corresponding values for each country.  I want to have a consolidated analysis of the countries by both systems, and see their corresponding values. What should I do? Sample attached below. 

Current value 

Target outcome

[#2 · Accepted solution]

@EmmaMeowMeow The easiest way would be to just copy list B below list A, under one header row. Add a column for the source (A or B) and create a pivot table from the list.

[#3]

Thanks @Riny_van_Eekelen , you are my idol of the day. Thanks so much!