Using SSMS, Table that looks like this

| Agent | Location |
| --- | --- |
| A | 1 |
| A | 2 |
| B | 3 |
| B | 4 |

---

How I run a query to get:

| Agent | Location |
| --- | --- |
| A | 1,2 |
| B | 3,4 |