How to Merge Data in Duplicate Rows in Excel. Spreadsheet applications like Excel are great tools businesses can use to process and analyze large amounts of data stored in tabular format.

You can easily discover the duplicate values in a Microsoft Excel spreadsheet using its conditional formatting duplicate highlighting feature.

If your source data is in Excel and has duplicates, run Power Query to remove those duplicates before running a Word mail merge.

If you want duplicate values to stand out in an Excel spreadsheet, you can choose between two conditional formatting rules.

In Numbers, create a spreadsheet that includes the data you want to merge. Launch the Pages Data Merge app and walk through the numbered steps.