Group by in Excel and sum values to create batch

[vickydas (vicky)]

Hello @Zahid1
you can easily do all the tasks using Linq

@Zahid1

I need to group the data by Site and my data should look like -

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.

@Zahid1

2. I need to create batch data for each site separately ( meaning I need to enter 4 records for first site) and sum the Amount of each sites ( FIS = 40 ) and store in different excel.

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 this workflow and excel for better understanding

Filter_Site.zip (28.0 KB)