How to group rows that have similar information into one row

Hi Team

I have a requirement where we need to add the matching data into a new column

Col1 Col2 Col3
A1 a raccon
A1 b deer
A1 c bear

Result will it be like ths

Col1 Col2 Col3 Col4 Col5 Col6 Col7
A1 a b c raccon deer bear

Where the matched value should be stored into a new column

A Manohar

Hi @Manohar1

Try this

DataView view = new DataView(table)
DataTable distinctValues = view.ToTable(true, "Column1", "Column2" ...)
DataTable =DataTable.DefaultView.ToTable(true)