Need to group similar items in a column of a second column in a single line in a report.
As follows:
Input
Field A Field B
----------- -----------
A1 B1
A1 B2
A2 B3
A3 B4
A3 B5
It would become:
Output
Field A Field B
------------ -----------
A1 B1, B2
A2 B3
A3 B4, B5
Cognos Version 12.0.4