Login / Sign up
Data cleanup

How to remove duplicate customer rows by email or external_id

2026-06-20
Task

Customer rows with the same email or external_id are grouped together. The export should contain one row per customer.

Short Answer

Enable Change row structure, choose Merge similar rows, and use email or external_id as the merge key.

How to Do It in Eofferix

  1. Open the email column settings in the table editor.
    Opening email settings
    The red frame shows where to open the required column settings.
  2. In Additional settings, enable Change row structure and choose Merge similar rows.
  3. Use email as the merge key. For another file, use external_id.
    Merging customer rows by email
    Rows with the same email are merged; other values are joined with a separator.
  4. Set a separator such as ; and save. Equal keys must be grouped together in the source table.

Before / After

Before

source data
external_idemailname
C-1001anna@example.testAnna Petrova
C-1001anna@example.testAnna P.

After

result
external_idemailname
C-1001anna@example.testAnna Petrova; Anna P.

Process data faster with Eofferix

Create a free account to automate catalogs and price lists around your own rules.

Sign up