So remove any rows with duplicates of the same first name (or with no first name).You are aiming to have only '2' with each row having a different first name (but related).Scroll down to Dup=2 column looking for rows with Dup=2 column being 3 or higher:.In the Duplicate sheet, sort the name column.Apply the formula to the whole column by double clicking the bottom right corner of the cell with the formula.Return (and you should see a number, eg: 1 or 2).Where i is the first row under the header row.

In the first row under the header add this formula: =COUNTIF( X: X, X i).

In the Duplicate sheet, insert a column before the email column and name it: Dup=2.

Right-Click (or Control-Click) the sheet tab > Rename: Duplicates.

Click on the new sheet and rename it duplicates.

Right-Click (or Control-Click) the sheet tab > Move or Copy.

If you haven't already duplicate the entire first name column and call the new column 'Custom First Name' Now when you scroll your spreadsheet a header row will always be visible at the top. Click on 'Freeze Panes' and select 'Freeze Top Row'. In order to lock excel header row, open the Microsoft Excel document. You have a different profiles (and rows on your export) for people with the same email address (ie a profile for John Smith and another for Mary Smith but they both share the same email address WITH EXAMPLE.įirst make sure you have a fixed header row: FeedsyMail - email and subscriber activity Combine duplicate rows with same email address

Move merge duplicate rows in excel