G
Guest
Hello Again,
I have a spreadsheet with 10428 line of vendor contact information, I need
to parse the lines as there are multiple duplicates for one reason or
another.
VENAME PHVND PHUDF1 PHUDF2
BA LA TURCA TEXTILES, LLC 128949 CHOWIE ALKAN 510-454-1729
BA LA TURCA TEXTILES, LLC 128949 ALKAN 510-454-1729
BA LA TURCA TEXTILES, LLC 128949 CHOWIE 510-454-1729
BA LA TURCA TEXTILES, LLC 128949 CHOWIE ALKAN 510-454-1730
A M LEONARD 212817 SHIRLEY REIBER 988-658-9665
A M LEONARD 212817 REIBER 988-658-9665
A M LEONARD 212817 SHIRLEY REIBER 800-444-0633
A M LEONARD 212817 SHIRLEY REIBER 988-658-9665
example above, there is really another phone number column, I need to put a
formula in a column to the right to find the duplicate records first by the 3
or 4 fields. Then I need to pear down the data to remove the duplicates, as
you can see some of the example if would have been matching except the forgot
to put the first name in the record so it looks like a different record. My
goal is to have 1 vendor name associated with 1 number with potentially
multiple contacts and contact numbers. Right now the data is jumbled because
of the garbage input. I hope I have explained this correctly, any help would
be great!
Thank you,
Lou
I have a spreadsheet with 10428 line of vendor contact information, I need
to parse the lines as there are multiple duplicates for one reason or
another.
VENAME PHVND PHUDF1 PHUDF2
BA LA TURCA TEXTILES, LLC 128949 CHOWIE ALKAN 510-454-1729
BA LA TURCA TEXTILES, LLC 128949 ALKAN 510-454-1729
BA LA TURCA TEXTILES, LLC 128949 CHOWIE 510-454-1729
BA LA TURCA TEXTILES, LLC 128949 CHOWIE ALKAN 510-454-1730
A M LEONARD 212817 SHIRLEY REIBER 988-658-9665
A M LEONARD 212817 REIBER 988-658-9665
A M LEONARD 212817 SHIRLEY REIBER 800-444-0633
A M LEONARD 212817 SHIRLEY REIBER 988-658-9665
example above, there is really another phone number column, I need to put a
formula in a column to the right to find the duplicate records first by the 3
or 4 fields. Then I need to pear down the data to remove the duplicates, as
you can see some of the example if would have been matching except the forgot
to put the first name in the record so it looks like a different record. My
goal is to have 1 vendor name associated with 1 number with potentially
multiple contacts and contact numbers. Right now the data is jumbled because
of the garbage input. I hope I have explained this correctly, any help would
be great!
Thank you,
Lou