how to extract data based on payment mode

[m9vukyem]

Please find attachment

 

[ETAF]

=FILTER(A2:C30,C2:C30<>"")
see columns P,Q & R
and
=CHOOSECOLS(FILTER(A2:D30,D2:D30<>""),1,2,4)
see columns T,U & V

assuming you have later version of excel 365

see columns

 

[m9vukyem]

Thank you sir but I am using 2016 excel version

 

[p45cal]

 

[ETAF]

not sure on 2016 , there is various methods , but quite a while ago now
=IFERROR(INDEX(Sheet1!A:A,AGGREGATE(15,6,ROW(Sheet1!$C$2:$C$30)/(Sheet1!$C$2:$C$30<>0),ROWS(A$2:A2))),"")
BUT that may not handle dupicates well ... and then lookup the rest of the items correctly

i'll have a think how best to do that - but hopefully other members can help

will the data ever have duplicate names in ?????