Moving data from a row to column based on dup

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,