Custom report splitting multiple checkbox property into separate lines

[Dom_Carlin]

I am trying to build  a table in the Custom Reporting tool. One of my columns is a multiple checkbox property, where a Company may have more than one selected. 

Ideally, this would show as "Option A, Option B" in the reporting column (same as it shows in a filter on the Company index page). Instead it is creating a new row for each of the options selected in that property. 

Is there anything I can  do to get it to display the logical way, with all of the options in the same column? 

[DianaGomez]

Hello @Dom_Carlin ,

Thank you for your inquiry.

After carefully examining the situation, it appears that data duplication is likely due to the usage of two distinct Data Sources. When identical information exists in both Objects, such as Companies and Deals, the report will retrieve data from each of these sources, leading to the duplication you are experiencing.

To resolve this matter, I would recommend opting for a single Data Source, which will prevent the display of redundant data.

If, however, you are already using only one data source and the issue persists, kindly let me know, and I will be more than happy to assist you further.

Best regards,

Diana