How to merge the cell of single table

Question

hi i had a table looks like

id      name   value 1   value 2    
1       a        50       NULL  
2       b        NULL     60          
1       a        NULL     80    
2       b        100      NULL

now i want to combine the output should be like

id  name  value 1   value 2   
1    a      50       80   
2    b     100       60

I generated this using view.

Answer 1

Use GROUP BY

SELECT id,  
       name,  
       [value 1] = MAX([value 1]),   
       [value 2] = MAX([value 2]) 
FROM dbo.YourView
GROUP BY id, name

Demo