Combining similar records

Any software related topics go in here.
Post Reply
User avatar
StarPhoenix
B.Soc.Sci, M.SocSci [UPCF]
Posts: 17634
Joined: 11 Dec 2003, 02:00
Processor: Core i5 3470
Motherboard: Gigabyte G1 Sniper Z77
Graphics card: nVidia GeForce GTX 1060
Memory: 8Gb DDR3 1600
Location: East London
Contact:

Combining similar records

Post by StarPhoenix »

I have an Outlook Contacts list with several years worth of data that I need to "clean" for my boss open in Excel. I have already removed the exact duplicates using the "Remove Duplicates" button, but am still left with a substantial number
of similar records [e.g. record 1 has name and landline number, record 2 has name and cellphone number, etc]. Is there
any way I can combine these records using [preferably] Excel or, at worst, Access, and how would I do it.

My online searches have not been successful thus far....must be using the wrong search times. :roll:

Thank you
"Humankind cannot bear very much reality." T.S. Elliot
User avatar
StarPhoenix
B.Soc.Sci, M.SocSci [UPCF]
Posts: 17634
Joined: 11 Dec 2003, 02:00
Processor: Core i5 3470
Motherboard: Gigabyte G1 Sniper Z77
Graphics card: nVidia GeForce GTX 1060
Memory: 8Gb DDR3 1600
Location: East London
Contact:

Re: Combining similar records

Post by StarPhoenix »

I have subsequently chatted to someone who professes to know Excel quite well about this.
This is something that is going to be easier for me to do manually, which is what I am doing now.
"Humankind cannot bear very much reality." T.S. Elliot
Bladerunner
Registered User
Posts: 14338
Joined: 04 Sep 2004, 02:00
Processor: i386DX Sooper
Motherboard: A blue one
Graphics card: A red one
Memory: Hard drive
Location: On a Möbius strip
Contact:

Re: Combining similar records

Post by Bladerunner »

I might be able to do it for you in SAS.
If I weren't insane: I couldn't be so brilliant! - The Joker
Post Reply