Jan 24 2022 12:42 AM
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
Jan 24 2022 01:54 AM
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.
Jan 24 2022 01:54 AM
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.