Crystal Reports Group footer

Message

     This is how the data is in Detail section of report. In this sample data there are 2 groups -

Group 1
col1        col2         col3
name1   event1    time1
name1   event2    time2
name1   event3    time3

Group2
col1        col2         col3

name2   event1    time4
name2   event2    time5
name2   event3    time6

On the final display of the report I want the data as below.

name1   time1   time2   time3 
name2   time4   time5   time6

I am trying to get this is the group footer by creating 3 different formulas.

formula1: if col2 = event1 then col3
formula2: if col2 = event2 then col3
formula3: if col2 = event3 then col3