Urgent Query: Excel Tables Issue

Hello,
I am new to Excel and I have this issue, Have 3 columns with example values:

i.e I have 3 columns with definite set of values: like column 1 can have P1 P2 P3 P4 as values.
Column 2 can have Open,Reopened,Closed,InProgress as values.
Column 3 can have values like Resolved,Unresolved,Verified,Fixed..

I wanna make a table look like this:

Column 1: P1,P2,P3,P4
Column 2: Open/InProg/Reopen
Column 3: Closed
Column 4: Resolved
Column 5: Verified

i.e basically generate table 2 from table 1 by comparison like which P1s are still open...which P1 are unresolved etc.. ...thanks...


I am automating it through a macro...Can anyone help me with the formula to develop this..??