I am trying to merge different rows into one when they have the same id but different column values in Microsoft sql. I found a discussion about the same need but in oracle see [link](https://stackoverflow.com/questions/40831690/sql-merge-two-rows-with-same-id-but-different-column-values-oracle)

i created the table in [sql fiddle](http://sqlfiddle.com/#!6/76881/1/0) 

for example, i have 

```
UserId  WorkGroup

Bill    PC-money
Bill    PC-windows
Linus   PC-free
Linus   PC-open

```

I would like to see

```
UserId  WorkGroup1 WorkGroup2
Bill    PC-money   PC-windows
Linus   PC-free    PC-open

```

my access to microsoft sql is read-only

thanks for you ideas