Forum Discussion
Solved
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 ...
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.
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!
