How to display a grid content in our format

Question

Hi

I have a store procedure..that store procedure i called in a gridview ..now my grid view look like this.

id  name  key  condition  operator  supplement
1  jana  officialwork  J  =  OR 
1  jana  officialwork  Home  =  OR
1  jana  personalwork  J  =  OR 
1  jana  personalwork  Home  =  OR

2  jana  personainsure  chemi  =  OR
2  jana  officialainsure  chemi  =  OR

Now i want to display like this
1 If officaialwork = J oR Home or officeVisit = J OR Home then Dr.jain


I want to display my grid view look like the above..that is in id 4 i have four rows that i want to club it as one sentence same like all id..  how to this..i didnt have a idea..plz share ur ideas