Data Display in Report

[Cogknow]

Hi

We have an issue with data display in one of our reports.

Below is the sample data that our query is fetching.

Col1 Col2   Col3         Col4               Col5          Col6
1   A   1234   Null               Checked      Null   
1   A   1234   UnChecled   Null           Null
1   A   1234   Null               Null           Checked
2   B   3456   Null               Null           Checked
2   B   3456   Null               Unchecked   Null
2   B   3456   Checked       Null           Null

We need to show data as below in the report

Col1 Col2   Col3         Col4                   Col5              Col6
1   A   1234   Unchecked   Checked      Checked
2   B   3456   Checked           Unchecked  Checked

Please help us in resolving this.