Hey everyone,
I have a question, I hope someone can answer. I have data I have to upload into a crm from a CSV file. It is contacts and companies, however the CRM will only take multiple contacts from a single company if they are on the same row. Right now the data is setup to have the contacts on seperate rows. Is there an easy way to do this using a *primary key* like company name to check for the duplicates and move the required data? Example below:
Company Name First Name1 Last Name1 First Name2 Last Name2
Company A John Smith
Company A Susan Mike
Company B Frank Johnson
Company B Mike Tam
From the example I would like to move all other contacts for Company A (or Company B) to the next available Firstname2, LastName2, etc, etc. Depending on how many contacts there are, they would simply move on the same line as the first version of the company name. I don't need column headers created as I can do that myself.
Hope someone has done this before and can help out... I have way too much data to do this by hand....
I have a question, I hope someone can answer. I have data I have to upload into a crm from a CSV file. It is contacts and companies, however the CRM will only take multiple contacts from a single company if they are on the same row. Right now the data is setup to have the contacts on seperate rows. Is there an easy way to do this using a *primary key* like company name to check for the duplicates and move the required data? Example below:
Company Name First Name1 Last Name1 First Name2 Last Name2
Company A John Smith
Company A Susan Mike
Company B Frank Johnson
Company B Mike Tam
From the example I would like to move all other contacts for Company A (or Company B) to the next available Firstname2, LastName2, etc, etc. Depending on how many contacts there are, they would simply move on the same line as the first version of the company name. I don't need column headers created as I can do that myself.
Hope someone has done this before and can help out... I have way too much data to do this by hand....
