Merge of records based on the record name

[jmedidi]

Trying to merge the records. appreciate the support

Existing :

DESCRIPTION	RESPONSE
Year	2024
Program	T555
Module Name	TECM
Release Date	10/7/2019
Program Milestone	DVP
Year	2025
Program	V720
Module Name	MCCE
Supplier's Company Name	ABC
Supplier's Release Engineer's Name	dummy@company.com
Release Date	3/5/2020
Program Milestone	TRE

Desired

DESCRIPTION	RESPONSE
Year	2024, 2025
Program	T555,V720
Module Name	TECM, MCCE
Release Date	10/7/2019, 3/5/2020
Program Milestone	DVP,TRE
Supplier's Company Name	ABC
Supplier's Release Engineer's Name	dummy@company.com

[atcodedog05]

Hi @jmedidi 

You can use summarize and merge the rows like below. Highlighted is the seperator

Hope this helps : )