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.34.0 for Windows 11 / 10 / 8 / 7 (44 MB)

Apple Logo Mac Download

v1.34.0 for Mac 12.x to 10.13 (52 MB)


Questions or problems?

Email support@easydatatransform.com