Removing duplicates while consolidating all cells within each duplicate on to one Row

Hello to all !

I have a 60000 line customer list, columns A - X.
Column A is an Email.
There are about 5000 duplicate emails addresses.
Within each duplicate email, columns B - X may have populated cells, IE Addresses, Country etc.
I want to de-dup the list while preserving or capturing / consolidating on one line all populated cells in columns B - X.

For example:
Row 2: Cell A2: Jimemail, Cell B2: 1/1/1970, Cell C2: blank
Row 3: Cell A3: Jimemail, Cell B2: blank, Cell C2: USA

My Goal is to consolidate on one line
Row 2: Cell A2: Jimemail, Cell B2: 1/1/1970, Cell C2: USA

Thank you,
Jim Kimball

HI Jim,

Can you post an example file with a about 20 lines and with duplicates. that makes it a lot easier to build a solution.
Please look at the yellowbanner at the top of your screen on how to upload (example) files to this forum.

Also, I can understand that you overwrite the blank cells with information from a duplicate that has a filled cell .
But what do you want to happen if 2 records have both filled for the same cell. Is there a way to know which value should get priority, for example is there a date column so you can say keep the record with the most recent date.

Hi Roel Jongman. Thank you for response. There is only one column (column header "TAGS") that may have populated cells in a duplicate email row. The information in those cells is not important. These cells can be overwritten to include one of the duplicated 2 cells information.

I will upload the sample file in just a moment. And again, thank you : )

file attached..