Merging Same Values into One Group

Functions

Businesses want to compile a list of all customers. However, in the original data, each customer may have made multiple purchases, resulting in multiple records. (Only one record of data is needed to keep.) You can use the Group Summary function to merge the same values into one group.

Implementation Method

Except the basic function (group data first and summary them then), Group Records with Same Value can also be used to remove duplicate data.

Uploading Data

1. Sample data: Store Sales Statistics.xlsx

2. Create an analysis subject and upload the sample data downloaded.

Removing Duplicate Data Through Group Summary

1. Click Group Summary and add relevant information to Group.

2. Save and update the analysis subject.

Only one record of data is retained for the same customer and you can get the needed customer list.