Datatable data manipulation - Structuring the table

[ppr (Peter Preuss)]

Duplicate of:

How do I do the Data Massaging as following in a data table?

Hi Team, I am having a table as shown below: Name Age Place Description Vendor User 1 23 Pune This is UiPath a description for user one User 2 24 Mumbai Demo of re UiPath quirements User 3 25 London UiPath is a autom UiPath ation tool User 4 26 Boston User four be UiPa longs to the Boston th in USA User 5 27 Delhi This is the la Ui st example to Pat make this line comple h ted And I wish to…

group by on 2 cols:

(From d In dtData.AsEnumerable
Group d By k1=d("Name").toString.Trim,k2=d("Place").toString.Trim Into grp=Group
Let dc = String.Join("",grp.Select(Function (x) x("Description")))
Let vc = String.Join("",grp.Select(Function (x) x("Vendor")))
Let ra = New Object(){k1, grp.First()("Age"),grp.First()("Place"),dc,vc}
Select dtResult.Rows.Add(ra)).CopyToDataTable