Heres the problem

I have a True DB grid with an id, name, notes, and product_id

this example shows 2 people with 3 products each.

Id | Name | Notes | Prod_id
---------------------------------------
1 John Doe testestest 100
1 John Doe testestest 101
1 John Doe testestest 102
2 Jane Doe blahblah 100
2 Jane Doe blahblah 101
2 Jane Doe blahblah 102

if i set the merge property to true on Id, thats perfect, b/c the user doesnt need to change that and it eliminates repetitive data. Same with Name. The Notes field is different. They only need to edit one Notes field per Id, but I was trying to figure out a way to eliminate the duplicate occurences in the grid while still allowing editing.

Is there any way to do this?

Any help would be appreciated