Transpone values to new columns?

Hi everybody,

i am wondering if it is possible to transpone single values of one column (from data feed) to many new columns?

Requirement:

- Column of data feed (PRODUCT) has the values: A, B, C

- Rows (with No. of products) looking like:

PRODUCT     |     #     |        ID

• A              |     23   |     4711
• A              |     14   |     4712
• A              |       3   |     4713
• B              |     10   |     4714
• B              |     20   |     4715
• B              |     20   |     4716
• C              |       2   |     4717
• C              |       4   |     4718
• C              |       4   |     4719

- Now, i would like to transpone it like in XLS to:

            A     |     B     |     C     |     ID

•    23          0           0          4711
•    14          0           0          4712
•      3          0           0          4713
•      0         10           0          4714
•      0         20           0          4715
•      0         20           0          4716
• etc.

Thanks for any idea or response if possible or not anyway.

Rgds, Martin