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
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.
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,
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.