Forum Discussion
Solved
Remove duplicates based on value on another column
Below is the sample data ID DOB Ethnicity Email 1 01/01/2018 British or Mixed aa.aol.com 1 01/01/2018 Other Mixed 2 02/05/2015 British or Mixed British 2 02/05/201...
Hi uc ,
Multi-select (Ctrl+click) [ID] and [DOB].
On the Home tab, go to Group By.
In the aggregate columns section at the bottom, create two aggregate columns as follows:
New column name: Ethnicity
Operation: Max
Column: Ethnicity
New column name: Email
Operation: Max
Column: Email
This gives me the following output:
Pete
Hi uc ,
Multi-select (Ctrl+click) [ID] and [DOB].
On the Home tab, go to Group By.
In the aggregate columns section at the bottom, create two aggregate columns as follows:
New column name: Ethnicity
Operation: Max
Column: Ethnicity
New column name: Email
Operation: Max
Column: Email
This gives me the following output:
Pete
