Filter By other column data in same Table

[sohailstsindia]

ProjTrans	RefTrans	OrigTrans	AMOUNT
208428			6
295865	208428		-6
295866	208428	208428	6

I need Like

ProjTrans	RefTrans	ProjTrans	Amount	OrigTrans	ProjTrans	Amount
208428	YES	295865	-6	YES	295866	6
	if(ProjTrans in RefTrans) then YES else No	if(ProjTrans = RefTrans && OrigTrans ="Null") then ProjTrans	if(ProjTrans = RefTrans && OrigTrans ="Null") then Amount	if(ProjTrans =  OrigTrans ) then "YES" Else No	if(ProjTrans =  OrigTrans ) then ProjTrans	if(ProjTrans =  OrigTrans ) then Amount

[v-juanli-msft]

Hi @sohailstsindia 

You transform the data circled by blue box 

To one row as follows

Right?

Best Regards

Maggie

[sohailstsindia]

Hi Maggie,

Yes I need like that please solve this.

Regards,

sohailstsindia 

[sohailstsindia]

Yes