Split single rows into multiple rows

[InertiaM]

Any quick ideas on how to write a query to split

TYPE      NAME         QTY
--------------------------
A         PROD1          3
A         PROD2          4
B         PROD6          1
B         PROD7          2
C         PROD9          2

into

TYPE      NAME
----------------------
A         PROD1
A         PROD1
A         PROD1
A         PROD2
A         PROD2
A         PROD2
A         PROD2
B         PROD6
B         PROD7
B         PROD7
C         PROD9
C         PROD9

would be greatly appreciated