How to Convert a multiple rows into single row with comma separated values

[Biswajit_1993]

HI @gururajgiri ,
Can you go through this link and check the solutions.

How to use values from a list aggregated field in a table to a filter in Quicksight?

I have a dashboard in Quick-sight where a table is being used which contains a field that has values list aggregated.(Please refer the attached image). I need to create a filter in a dashboard that will have a dropdown with distinct values from the list aggregated values so that if i select/check a particular value from a dropdown then it should filter out the list aggregated record by matching the string i selected in a drop down. I tried to use the split function to get the distinct values f…

Or you can use custom SQL to extract multiple rows into single row with comma separated values.

Thanks & Regards
Biswajit Dash