I have a data table with 2 columns I want to group the data by column 1 and join the data in column 2 with ^ separating each value. I have a simple example below of data and then what I want the output to be, but I’m struggling with how to write something to accomplish this. [image]

Group data table by value and join results in caret list

ppr (Peter Preuss) June 8, 2020, 8:01am 5

@db44
Cool thing that the Statement form post was directly working without syntax issue.

Just test it at your end and let us know your feedback

Group datatable by column

Topic		Replies	Views
Group by column and string join Studio datatable , activities , question	5	735	April 10, 2023
Group by Studio	3	627	November 19, 2022
Linq group by and concatenate Studio	3	1579	August 26, 2022
DataTable group by questions Studio studio , question , activities_panel	9	854	October 17, 2022
Group two column values with unique column Studio datatable , studio , question	9	1154	November 20, 2022