Displaying data in a columnar format

[dlusion]

Hello,

I am currently working on a report where its displaying information by row. I would like to display the information in a columnar format. The report is being created using Crystal version 10 and the data source is an excel sheet. The sample of the information is attached below also how the final output should look like.
-----------------------------------------------
This is how the report looks like right now:

EE Name,PlanCode,Member,
Tom Jones,1,Mike,
Tom Jones,1,Dave,
Tom Jones,1,Sahra,
Tom Jones,2,Dave,
Tom Jones,,,
Tom Jones,,,
Sally T.,1,Jessica,
Sally T.,,,
Sally T.,2,Jessica,
Karen,2,Will,
Karen,2,Bill,
Kim,,,
John H.,1,Craig,
John H.,1,James,
John H.,2,James,
-----------------------------------------------
This is how the final result should look like:

EE Name,PlanCode1,Member1,Member2,Member3,Member4,Member5,PlanCode2,Member1,Member2,Member3,Member4,Member5
Tom Jones,1,Mike,Dave,Sahra,,,2,Dave,,,,
Sally T.,1,Jessica,,,,,2,Jessica,,,,
Karen,,,,,,,2,Wil,Bill,,,
Kim,,,,,,,,,,,,
John H.,1,Craig,James,,,,2,James,,,,


Thanks in advance.