I've got the following data:

ITEM TYPE QTY

A II 10
A IM 20
A IT 30
A OH 40


I want to query this table and produce a single row:

ITEM II IM IT OH
A 10 20 30 40

Can I do this?