Need resultset on following resulset in sql : I have result set as follows,
**Employer_id	Type	Amount**
1	penalty	100
1	interest	120
2	penalty	50
2	interest	60
2	contribution	70
1	contribution	140

I need result as,
**Employer_id  penalty interest contribution**
1				100		120		140
2				50		60		70

Is it possible in sql? can anyone provide query if possible.