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 |
Hi @jmedidi
You can use summarize and merge the rows like below. Highlighted is the seperator
Hope this helps : )