I have a table eg

employee type value
001 salary 1500.23
001 expenses 120.00
002 salary 1600.50
003 salary 1600
003 bonus 300

And want the table to look like

Employee salary expenses bonus
001 1500.23 120 0

Any ideas

Thanks