Displaying Heirarchical Data in one row

[showtime14]

I have a gridview that displays in the following manner. What I am trying to accomplish to is if you see the columns with the heading(s) Name, LegName, MedicalConditions, DateofBirth and id displays as two rows, as it normally would, but what I would like to do is to have all that data display in ONE Row because it all belongs to one registration. If you look at the two attachments, image one is how the data comes out of the DB normally. Image two is how I would like to be. Please keep in mind that this is a small example and I actually have more fields than just this, so I am looking for something extensible.

I am really looking for help here and anyone that could point me in the right direction it would be greatly appreciated. Thanks for your help!

[Andy2009]

You need to do from database side, either stored procedure or db script to group by the id ahead of time. It will display one row after you done that