Repeater Object Issue in the CSV

[davidcognos]

Hi Team,

I am using a Repeater object in the report to show a column data to display in a single cell of a row which is the requirement. The repeater works fine and output shows properly in excel but when ran in csv, the repeater object won't work properly and some of data gets truncated. So the repeater object wont work properly in csv is what i understand. But is there any other alternate way of doing this requirement?? we don't have access to the database for this package. And other thing is that the excel output when made a save as in csv shows the trailing commas at the end of the header and and the footer which is not correct, and this approach is also of no use. Any ideas or anybody faced this issue??

Actual data:
-------------
col1    col2
1           a
1            b
1            c

Required:
---------
col1       col2
1             a,b,c