Need help in performing Excel action

Hi Everyone i have an issue in excel action i have a excel data in excel, i want to filter that data and need to write in another excel.
name and mobile no is same for all but items will be changing i need to write their name and mobile number once and need to write items in row by row. i’m attaching my excel with input and output.
Test.xlsx (9.5 KB)

@Rana_Reddy

Welcome to forums

You can check below link for your reference

Reference

Hope this may help you

Thanks

Hi @Srini84 my requirement is opposite to that video , can you check my attached excel i kept input and output in it.

Hi,

Hope the following helps you.

img20211130-4

dt = dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r("Name").ToString,r("Mobile").ToString)).SelectMany(Function(g) g.Select(Function(r,i) dt.Clone.LoadDataRow({if(i=0,g.Key.Item1,""),if(i=0,g.Key.Item2,""),r("item").ToString},False))).CopyToDataTable()

Sample20211130-2.zip (9.3 KB)

Regards,

Thanks @Yoichi it is working

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.