Hi, 

I hope someone can help. I am creating a crystal report and the data coming in looks as follows

Id              Course                  Course Completed

100           ABC                         09/25/2011

100           DEF                          09/16/2011

101           ABC                         10/01/2011

103           DEF                          09/14/2011

105 

I created a crystal report to group on ID. I need the report to look as follows

Id            Course ABC                                     Course DEF

100         ABC completed on 09/25/2011   DEF completed on 09/16/2011

101        ABC completed on 10/01/2011    DEF Not completed

103        ABC Not completed                         DEF completed on 09/14/2011

105        ABC Not  completed                        DEF Not completed

How do I set up the formula to do this ?

Thanks in advance