Split an excel sheet into multiple based on a column value

[vickydas (vicky)]

Hello @Yusuf_Rahmaniac

I wrote a simple Linq query for a case similar like yours check this link

Group by in Excel and sum values to create batch

Hello @Zahid1 you can easily do all the tasks using Linq You can do this task using OrderBy method.It’ll sort all the data as shown in the image and it’ll write the data in a new sheet. For this task first i grouped all the data and took the distinct value’s than looping those data filtered it one by one and wrote in a different and naming the sheet of the site. So what we get is a batch of different and then used Sum method to sum the Amount Column and wrote it in our batch Sheet. Check…

Let me know if you didnt get any part !!