I am using SQL2012. I have the following SQL table which shows case number and their value. The case number always appears 3 cases as a group. Can you help me to pivot the table? The number of case number is more than a thousand. 

```
case  value
A     1992
A     1956
A     2007
B     2000
B     2001
B     1990
C     2000
C     1956
C     1817

```

Expected result:

```
Case  value1   value2   value3
A    1992      1956     2007
B    2000      2001     1990
C    2000      1956     1817

```