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