I have this table

| id | cnt1 | cnt2 |
| --- | --- | --- |
| 7775 | 1 |  |
| 7775 |  | 2 |

I would like to combine the rows so that it comes out to this

| id | cnt1 | cnt2 |
| --- | --- | --- |
| 7775 | 1 | 2 |

I've tried a self join but it only appends the rows to the bottom. Any ideas? thank you!