Crystal Reports Show multiple records in 1 row

Message

     Hi,

I've created an inner join (CR X1) that produces multiple records for each Id;

Id   type   typedescription
1     a        blue
1     b        green
2     a        yellow
2     b        orange
2     c         pink
3     a        blue
3     b        orange

How do I get the data for each Id to show in 1 row in the report?

Id   type a   type b    type c   
1     blue      green       
2     yellow   orange   pink

3     blue      orange

Thank you.