Creating a table (like a pivottable in Excel)...how?

I have a table in my DB with the following columns: PlayerID, RoundNum, Score.

PlayerID RoundNum Score
1 1 10
1 2 10
1 3 10

Any scoring for my game is going to end up in this table. However, I would like to display the score standings with a player's name at the far left, and with each Round as a column:

R1 R2 R3
Player1 10 10 10

Can any of the SQL gurus tell me if this is possible, and how it can be done? Thanks!

http://forums.asp.net/1194798/ShowPost.aspx|||That is exactly what I was looking for. Thanks for a) giving the inital explanation and b) pointing me to it.