Concatenate values

Question

Hellow Sixthesense!

I have a table as below.

PO CATEGORY LINE ITEM A X 1 A X 2 A Y 3 B X 4 B X 5 C Y 6 D Y 7 D Y 8 D Z 9 D Y 10 E X 11 E Y 12 E Y 13 E Y 14 E Z 15

I want to see the result as below:

PO CATEGORY RESULT A X A Y B X C Y D Y D Z E X E Y E Z

Result column should have Line Items from the mother table concatenated against each PO and Category, probably separated by comas. For e.g. A - X - 1,2.

Sasi

Answer

Sasidhar,