Help in SQL Syntax

Copper Contributor

How to convert the below table1 into table2 using SQL? Please help. 

 
table1
 
Year  | Month | Amount
2001 | 1111 | 1.2
2001 | 1112 | 1.3
2001 | 1113 | 1.4
2002 | 1111 | 2.2
2002 | 1112 | 2.3
2002 | 1113 | 2.4
 
 
table2 
 
Year | m11 | m12 | m13 
2001 | 1.2 | 1.3 | 1.4
2002 | 2.2 | 2.3 | 2.4
0 Replies