How to merge rows in Excel

Easy Data transform can merge/consolidate/aggregate multiple rows of data that have one or more common values (e.g. a ID field) into a single row. For example, you might want to merge every row with the same customer ID into a single row, while also:

merge rows in Excel

See the video above for a quick overview of how to do this using the Unique transform.

As well as merging rows, Easy Data Transform also allows you to merge multiple datasets using Stack and Join transforms.

Try it free now!

Windows Logo Windows Download

v1.46.5 for Windows 11 / 10 / 8 / 7 (47 MB)
Zip file version

Apple Logo Mac Download

v1.46.5 for Mac 14.x to 10.13 (79 MB)

No commitments.
You can uninstall any time.
You don't even have to give us your email address.

Questions or problems?