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)


Welcome to forums

You can check below link for your reference


Hope this may help you


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


Hope the following helps you.


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() (9.3 KB)


Thanks @Yoichi it is working

1 Like

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