Creating a summary table from a straight table

[sayadutt]

Hi All,

I have a straight table  and looking for a summary table as shown below:

Now I am looking for a summary table which will group the projects and show the all the issues comma separated.

Also, status column should be based on :

Complete - once ALL the individual status for that project move to "complete".

In progress - when ANY of the  individual status for that project is still under to "in progress".

Not Started - when All status are Not started

[sunny_talwar]

May be just Max(Date)