asp.net (c# or VB) report from sql query with combined fields

I have been working on a web based report from an existing client/server apps sql database.? I have a working query and can provide the query and a result set.? The results currently? are similar to? this. ID : Name1 : Date1 : Veh? : PO 1? : Bob 1 : 12/1? : Car? : 1234 2? : Sam? ? ? : 12/3? : Car2 : 2245 2? : Joe? ? : 12/4? : Van1? : 5568 3? : Mel? ? : 1/4? ? : Van2? : 5678 4? : Mel? ? : 2/2? ? : Car? ? : 3456 4? : Sam? ? : 2/3? ? : Bus? ? : 4565 4? : Joe? ? : 3/4? ? : Car? ? : 6766 The Problem is that I don't know ahead of time if each ID will have 1 or many lines.? I need the results to return a combined line. Similar to ID : Name1 : Date1 : Veh? : PO 1? : Bob 1 : 12/1? : Car? : 1234 2? : Sam, Joe? : 12/3? : Car2, Van1? : 2245, 5568 3? : Mel? ? : 1/4? ? : Van2? : 5678 4? : Mel, Sam, Joe : 2/2? : Car, Bus, Car? : 3456, 4565, 6766