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.