Multiple the same email address but only one data display

Hi all,

We are having a program where there is a voucher serial as a UNIQUE KEY of a supplemental table. So the logic is there will be customer_ID or email address (They could have the same email address or id) but have multiple records or multiple serial number. Now, we are testing our program we are using FILTER/SQL view for this. We receive two same email address but it only shows same record for each.

For example:

DATA

Header 1	Header 2
EMAIL_ADDRESS_	SERIAL NUMBER
test@test.com	ABC123
test@test.com	ABC234

WHAT WE RECEIVE (TWO EMAILS, SAME DATA)