Datatable data manipulation - Structuring the table

[hacky (NotHacker)]

Hi Team,

I have the data in a data table as follows:

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 1	25	London	UiPath is a autom	UiPath
			ation tool
User 1	26	Boston	User four be	UiPa
			longs to the Boston	th
			in USA
User 1	27	Delhi	This is the la	Ui
			st example to	Pat
			make this line comple	h
			ted

And I want a data as follows:

Name	Age	Place	Description	Vendor
User 1	23	Pune	This is a description for user one	UiPath
User 2	24	Mumbai	Demo of requirements	UiPath
User 1	25	London	UiPath is a automation tool	UiPath
User 1	26	Boston	User four belongs to the Boston in USA	UiPath
User 1	27	Delhi	This is the last example to make this line completed	UiPath

Please help me with the same. EXPERTS please help me - @yoichi, @Hiba_B , @Pankaj.Patil

Thanks and Regards,
hacky

[hacky (NotHacker)]

PLease help guys - @prasath_S , @Hitesh1

[Yoichi]

Hi,

Hope the following helps you.

Sample20210623-2.zip (9.8 KB)

Regards,

[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

[hacky (NotHacker)]

@Yoichi

Thanks alot mate! I really appreciate it.

As usual, your solution was ideal and accurate in my case!!