excel formula

The goals is de-dup based on any header selected but preserve selective dedup data into the remaining unique record. For this example we will choose the first field which is Group_Legal_Business_Name and search list of uniqueness. I also want to change formula to use phone number or other field for uniquness if required. If Dups – Servicing County name field should be appended to the primary record separated by a “;” So 212 Chiropractor LL would be de dup and have servicing county filed updated to include include: Venango;Crawford;Mercer;Forest;Clarion;Warren. These are from the duplicate listings. The same should also apply to specialty column and phone no.. phone for example: 3308562112;3308562111 There should be no repeated names in the Servicing County for each row or specialty. All duplicates will be flagged