Hi All,
I have a query regarding datatable, In my scenario, I have data like PartNum, MaterialNum, and quantity, I want to merge into a single row when PartNum and MaterialNum are the same but the quantity should be the sum of all the rows, Please see the sample data below. Kindly help me with this.
Thanks in advance!
Input:
Required Output: