Need help to change in Data Table format in excel using Uipath

[Indranil_Dey]

Hi All,

Want help on UiPath !
I want to create data format from Col A and B

as Col D & E

[Yoichi]

Hi,

Can you try the following sample?

dt = dt.AsEnumerable.GroupBy(Function(r) r("VENDOR".ToString)).Select(Function(g) dt.Clone.LoadDataRow({g.Key,String.Join(",",g.Select(Function(r) r("MDG REQUEST").ToString))},False)).CopyToDataTable

Sample
Sample20231026-4L.zip (9.3 KB)

Regards,