I have a problem in excel that is very urgent to resolve. I have a table that contains duplicate records e.g two people living at same address. I want to merge those records whose HouseholdID field value are the same.
Please find attached an excel sheet that contains the exact data. I will be using this data to do a mail merge in MS Word so I can print labels. I know it requires VBA coding and I would really appreciate if anyone can help me in resolving this.
Bookmarks