# Best way to merge records with a common field into a list **URL:** \ **Category:** CloverDX Platform\ **Created:** [May 6, 2021, 12:00am UTC](https://forum.cloverdx.com/t/best-way-to-merge-records-with-a-common-field-into-a-list/2111 "2021-05-06T00:00:00Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![bea95](https://avatars.discourse-cdn.com/v4/letter/b/ce73a5/32.png) [@bea95](https://forum.cloverdx.com/u/bea95)\ **Post date:** [May 6, 2021, 12:00am UTC](https://forum.cloverdx.com/t/best-way-to-merge-records-with-a-common-field-into-a-list/2111/1 "2021-05-06T00:00:00Z")
Hi there, I have some data that looks like this where there are duplicate values in field 1 and different values in field 2. Field\_1 Field\_2 95791982 4558330929 95791982 6811305815 95791982 2077056935 75612428 7349717965 75612428 9718912488 75612428 7376005892 Would be very grateful if someone could advise on the best way to achieve something that looks like: Field\_1 Field\_2 95791982 4558330929,6811305815,2077056935 75612428 7376005892,9718912488,7376005892 Thank you in advance! ---
**Author:** ![Ladislav\_Szabo](https://yyz1.discourse-cdn.com/flex007/user_avatar/forum.cloverdx.com/ladislav_szabo/32/168_2.png) [@Ladislav\_Szabo](https://forum.cloverdx.com/u/Ladislav_Szabo)\ **Post date:** [May 10, 2021, 10:37am UTC](https://forum.cloverdx.com/t/best-way-to-merge-records-with-a-common-field-into-a-list/2111/2 "2021-05-10T10:37:07Z")
Hello there! There is a component in CloverDX made exactly for this called “Denormalizer”. Denormalizer creates a single output record from one or more input records. I’ve attached a graph with my solution so you can have a look at it. (You could go with setting group size instead of key if there’s fixed number of records with same key, however using key is safer.) Be sure to check documentation to find more about Denormalizer. Best regards, Ladislav. - [Project.zip](https://cdn.cloverdx.com/forum/19394%5Fe1e99136c60645ed06e025363f4b9cc0/Project.zip)