Two contact lists with overlapping people merged into one, with duplicates removed even when capital letters and spacing differ, and missing phone/city details filled in from the duplicate rows. Checked: 6 rows in, 4 unique out, 2 duplicates listed. Demonstration sample using invented data. Not client work.