how to display columns data values in row wise in SAP BO (webi)

Hi All,

we have 2 objects ,the data display in the webi report like below .

[Object 1] [Object 2]
C000029 AL14
C000029 ANA021
C000029 R18
C000029 ANA029
C000032 AL14
C000032 ANA021
C000032 R18
C000032 ANA029

but we need to show [object2] values in single row like below

[Object 1] [Object 2]
C000029 AL14 | ANA021 | R18 | ANA029
C000032 AL14 | ANA021 | R18 | ANA029

how to write the logic/function ..any one help on this ..

Thanks,

Ramesh