Forum Discussion
Help needed! Partially duplicated country list in two columns with different corresponding values
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
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.
2 Replies
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.
Thanks Riny_van_Eekelen , you are my idol of the day. Thanks so much!
