Hi All,
I have data in below format -
My req -
1.
I need to group the data by Site and my data should look like -
- 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.
Any help or xaml will be appreciated.