I have a column structure in gridview
account dept1 dept2 dept3
1 1
1 1
1 1
2 12
3 1
3 12
These rows are different records from database.
I want to have
account dept1 dept2 dept3
1 1 1 1
2 12
3 1 12
Is there a way to hide rows and display data correctly.
Right now I have data in a dataset in c#.