Combine data in datatable

[Ritika_Singh]

Hi ,
I have the below input data:

I want the data in the below format:

Data_Format.xlsx (8.5 KB)

[Ritika_Singh]

Hi @Yoichi ,

Any inputs from your end would be of great help.

[varunk (Varun Kumar)]

Using lookup we can able to get the data & write in excel

[Yoichi]

Hi,

Hope the following helps you.

dtResult = dt.AsEnumerable.GroupBy(Function(r) r("Name").ToString).Select(Function(g) dtResult.LoadDataRow({g.Key,String.Join(vbcrlf,g.Select(Function(r)  String.Format(strTemplate, {r("Layer").ToString,r("Name Code").ToString,r("Percentage").ToString,r("Certificate Number").ToString})))},False)).CopyToDataTable()

Sample20220308-3.zip (9.0 KB)

Regards,

[Ritika_Singh]

I have additional requirement . I have attached the excel for your reference . If for a intermediary there is same layer multiple times the the layer name should exist only once. Please refer intermediary 1 layer 1 in the attached excel
Data_Format.xlsx (8.6 KB)
result.xlsx (9.1 KB)

[Yoichi]

Hi,

How about the following?

Sample20220308-3v2.zip (21.9 KB)

Regards,

[Ritika_Singh]

Thank you @Yoichi . It worked…