Concatenate 3 rows into 1

[SiGill]

I need to concatenate a few rows into one, I have read and tried a few things on here but can't get anything to work. This is what I have

ID Team Player Name
1 Team1 Mark
2 Team1 Paul
3 Team1 Arnold
4 Team2 Ralf
5 Team2 Bill
6 Team2 Simon

I want to be left with just 2 columns, like

Team Players
Team 1 Mark, Paul, Arnold
Team 2 Ralf, Bill, Simon

Any help would be appreciated.

Thanks

 

[SOS]

Try this out.