Your after example is containing a duplicate (last two). Select the entire data, use DATA → REMOVE DUPLICATES → USE columns ADDRESS 1 , ADDRESS 2 AND ADDRESS 3. Make sure to use "my Data has headers".