Create a report from two sheets but some of the data is the same


I have two sheets that I want to merge into a report but some of the rows are in both sheets as they are either Phase 1 only, Phase 2 only or Both Phases. When they are in both Phases they are in both sheets for many reasons that I will not go into.

Do I need to create 1 further sheet which only has the countries that are in both phases detailed once or is there a way i can bring these into a report from the two sheets?



Best Answer