merged duplicate row and summed values in data gridview

Hello Rajadurai,

Please use below query(add other fields in your query, here I have added few for example), You can achieve using sql query by doing sum of quantity field

SELECT 
    id, 
    unit, 
    area, 
    Line, 
    idenCode, 
    Category, 
    SUM(Quantity) AS TotalQuantity
FROM 
    YourTableName
GROUP BY 
    id, 
    unit, 
    area, 
    Line, 
    idenCode, 
    Category;