I have a view which I created to report results. I am trying to get all of the results to show up on a single line. They are currently showing on each individual line. How could I go about getting all the data to show onto 1 row for each ID#?

```
IF EXISTS (SELECT TABLE_NAME 
       FROM   INFORMATION_SCHEMA.VIEWS 
       WHERE  TABLE_NAME = N'PBI_TrendData_VW')
    DROP VIEW PBI_TrendData_VW
GO
Create view dbo.PBI_TrendData_VW as

     SELECT distinct 
    Orders.Ordno as [ID#],
    CASE WHEN Analyte = 'DM1' THEN CONVERT(DECIMAL(10,2),(100-convert(float,Results.rn2))) END [Moi],
    CASE WHEN Analyte = 'DM1' THEN CONVERT(DECIMAL(10,2),(convert(float,Results.rn2))) END [DM1],
    CASE WHEN Analyte = 'CP' THEN CONVERT(DECIMAL(10,2),(convert(float,Results.rn1))) END [Protein]
 FROM   (((FOLDERS 
 INNER JOIN ORDERS ON FOLDERS.FOLDERNO=ORDERS.FOLDERNO) 
 INNER JOIN RESULTS ON ORDERS.ORDNO=RESULTS.ORDNO))
 WHERE  RESULTS.SA='Released'  
 GROUP BY ORDERS.ORDNO, Results.RN1, Results.Rn2, Results.Final, results.analyte

 GO

```

Current outcome:

```
|ID# | Moi | Dm1 | Protein |
|1   | 50  | Null|    Null |
|1   |Null | 50  |    Null |
|1   |Null | 50  |    22.4 |
|2   |Null | 25  |    Null |
|2   |75   |Null |    Null |
|2   |Null |Null |    32.4 |

```

Expected outcome:

```
|ID# | Moi | Dm1 | Protein |
|1   | 50  | 50  |    22.4 |
|2   |75   | 25  |    32.4 |

```