Formula to copy text from a cell, if two other cells have the same text

HI ,

I have a spreadsheet with about 3000 rows. The spreadsheet contains names of clients, First name, last name, a contact email address. The same client name is repeated in another row for an alternate contact email address. We are updating our system, where we would like to delete the second line of information and place the alternate contact's email address in the first row. Is there a way I can set up a formula to move the alternate email address to the first row, without copying and pasting manually. Any pointers will be of great help. Thanks.

You Can do this with a formula.

difficult to help without a sample.

If your main data is in an even row and your supplementary row is the next rowthen in something like this entered into a cell in row 1 and filled down:-

Please Login or Register  to view this content.

You then need to copy paste values

Sort by name

delete the redundant rows