How to condense into one table with only one value

[Arturo_CM]

I have this table that I don't want to change the order, want to generate a table with the logic where if any active for same CFN outcome will be active, if no all discontinue or no active then outcome is Discontinue

CFN	GTIN	DCHAIN	GTIN Status
A	1	DR	Active
B	5	X0	Discontinue
B	8	XX	Discontinue
D	7	OI	Active
E	11	X0	Discontinue
B	4	X1	Active
D	9	PP	Discontinue
E	10	PP	Discontinue
A	3	XX	Discontinue
D	7	OI	Active
B	6	PP	Discontinue
E	12	99	Discontinue
E	13	XX	Discontinue
A	2	X1	Active

OutCome
CFN	CFN Status
A	Active
B	Active
D	Active
E	Discontinue

[#2 · Accepted solution]

CFN Outcome
A Active Discontinue Active Active
B Discontinue Discontinue Active Discontinue Active
D Active Discontinue Active Active
E Discontinue Discontinue Discontinue Discontinue Discontinue