Duplicate Finder
Find, copy, and delete duplicates in one list or between two lists.
Merge Data Assistant
An add-in for Microsoft Excel that combines entries in multiple cells into one cell.
- Combine entries in multiple cells into one cell
- Combine by rows or columns
- Combine with spaces, returns, commas, or any character or text
- Combine in address style, where the last entry is a space and zip code
The Merge Data Assistant add-in for Microsoft Excel will combine entries in multiple cells into one cell. The following is the main dialog:
The first option allows you to merge entries on multiple rows into one row. In this case the entries in a column are merged and the duplicate rows deleted — deletion of duplicate rows is an option. The following illustrates a typical before-and-after using the second option to merge cell entries:
You can merge as many columns as you want in any order you want. The text from the different cells can be separated with spaces, commas, or any of several other options.
The Merge Data Assistant is entirely menu-driven.
Related add-ins
Data Cleaner
Clean and standardize spreadsheet data.