How can I perform concatenation in UI Builder presentation list

[AshutoshKr22]

Hi Community,
I have a presentation list on the UI Builder, there I have some duplicates records with same product number only the product type is different. When user is selecting product type from the dropdown filter, if he select single product type it's showing that record, and if user is selecting multiple product type duplicate records are showing as product number is same but type is different.
I want to implement if user is selecting multiple product type and there is duplicate records, then single record should came and product type will be concatenated.
eg:

Input:

Product Code	Product Name	Product Type
PROD00123	Toy	Car
PROD00123	Toy	Bike

Here, if user is applying multiple product type filter as car and bike both,

Output:

Product Code	Product Name	Product Type
PROD00123	Toy	Car, Bike

It should be changed on the UI only not in the table.

[RitheshB]

Hello
You can use the component formula editor in the configuration panel. The formula editor allows you to bind or modify data using logical, arithmetic, comparison, and functional transforms. By creating a formula that groups records by product code and concatenates the product types, you can ensure only unique product codes are shown, with their types combined in a single field. This transformation is applied at the UI level and does not affect the underlying table data