Asp.Net VB or C # how to combine rows and columns based on a unique primary field

Question

I am working on a web report from an existing mssql database for client-server applications. I have a working query that combines this information from many tables and can provide a query and result if necessary.

Currently, the results are similar.

ID | Name1 | Date1 | Veh  | PO    | Stops
_________________________________________  
1  | Bob 1 | 12/1  | Car  | 1234  |  4  
2  | Sam   | 12/3  | Car2 | 2245  |  3  
2  | Joe   | 12/4  | Van1 | 5568  |  2  
3  | Mel   | 1/4   | Van2 | 5678  |  5  
4  | Mel   | 2/2   | Car  | 3456  |  4  
4  | Sam   | 2/3   | Bus  | 4565  |  3  
4  | Joe   | 3/4   | Car  | 6766  |  3 

The problem is that I do not know in advance if each ID will have 1 or more lines. I need results to return a combo row, combine data from multiple columns, and add another one.

Similarly

ID | Name1         | Date1 | Veh           | PO                |  Stops
1  | Bob 1         | 12/1  | Car           | 1234              |  4  
2  | Sam, Joe      | 12/3  | Car2, Van1    | 2245, 5568        |  5  
3  | Mel           | 1/4   | Van2          | 5678              |  5  
4  | Mel, Sam, Joe | 2/2   | Car, Bus, Car | 3456, 4565, 6766  |  10  

Answer 1

SQL-, COALESCE SQL Server. .

Answer 2

- ( sql)

DECLARE @Table TABLE(
    ID INT,
    Name1 VARCHAR(50),
    Date1 VARCHAR(6),
    Veh VARCHAR(50),
    PO VARCHAR(10),
    Stops INT
)

INSERT INTO @Table SELECT 1,'Bob 1','12/1','Car','1234',4   
INSERT INTO @Table SELECT 2,'Sam','12/3','Car2','2245',3   
INSERT INTO @Table SELECT 2,'Joe','12/4','Van1','5568',2   
INSERT INTO @Table SELECT 3,'Mel','1/4','Van2','5678',5   
INSERT INTO @Table SELECT 4,'Mel','2/2','Car','3456',4   
INSERT INTO @Table SELECT 4,'Sam','2/3','Bus','4565',3   
INSERT INTO @Table SELECT 4,'Joe','3/4','Car','6766',3  

SELECT  *
FROM    @Table

SELECT  t.ID,
        (
            SELECT  tIn.Name1 + ', '
            FROM    @Table tIn
            WHERE   tIn.ID = t.ID
            FOR XML PATH('')
        ) Name1,
        MIN(Date1) Date1,
        (
            SELECT  tIn.Veh + ', '
            FROM    @Table tIn
            WHERE   tIn.ID = t.ID
            FOR XML PATH('')
        ) Veh,
        (
            SELECT  tIn.PO + ', '
            FROM    @Table tIn
            WHERE   tIn.ID = t.ID
            FOR XML PATH('')
        ) PO,
        SUM(Stops) Stops
FROM    @Table t
GROUP BY t.ID