Concatenating dataitem from multiple rows into a single column

[suhas_bhat]

Hi all,
   I am using a relational package and a list report.
Currently my report looks like this
Col 1 | Col2
A       | abc
A       | xyz
B       | def
C       | pqrs
C       | tuv
I want to display it like this
Col 1 | Col2
A       | abc;xyz
B       | def
C       | pqrs;tuv
Is there any technique to achieve this??
I have tried group by, running count along with conditional styles but data still appears on different rows. I need to concatenate the data into a single row.
Please help.

[kattaviz]

Hi,

Have u tried repeater table option. I think this can be acheived by using Repeater.

HTH

[suhas_bhat]

Hi Kattaviz,
   your soln. of using a repeater works perfectly.
I had fact1 being joined with fact2 to make final_qry.
I have made a copy of final_qry and used the copy for Col2 (which is in a repeater) while the original final_qry is used for the entire list.
Thanks.