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
Bookmarks