Moving data from a row to column based on dup

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? I have attached an example of what I have.

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....

Originally Posted by jeffreybrown

Hi scooby103 & welcome to the Board,

Please take a few minutes and read the Forum Rules about cross posts.

Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere.

It is prefered that you not cross-post at all, but if you do, please provied a link to the cross-post. http://www.mrexcel.com/forum/showthread.php?t=518374

Alright Jeffrey... will do. As they are not the same *forum* I only assumed that posting in multiple places would increase the likely hood of me getting a response. I will show the post to other sites going forward.

Now, with that being said, do you have a solution to the question?

Tks,

Originally Posted by jeffreybrown

So are you saying you would like Frank to move to D2, Johnson to E1, Tammy to F1, Tam to G1 and so on?

Essentially, but it needs to be based on the Company Name. So, if the same company exists grab the other contact information from the duplicate company and plug it into blank contact firstname2, etc. If the company doesn't exist don't do anything and move to next down the row.

Tks,