permutation combination but not mathematical

Question

I have a data with 5 columns and lakhs or records, where in sometimes there is data in 3 columns, sometimes only in one columns and sometimes in 2, etc, based on these 5 column conditions my 6th column has to populated, the values are totally different from the 5 columns.

CODENAMEPANTANLANRESULT12 TH  SKY ABC  CY45GROUND33  89 AIR

Raj · Answer

@Aakanksha_chandak you need to give some more context about the challenges where you need the help.

CoG · Answer

What is it that you need assistance with? I'm not sure I understand what it is that you're looking for.

Aakanksha_chandak · Answer

CodeGLAccountNameDeducteeCodeKeywords as per PO DescKeywords as per INV DescDeducteeStatusTDSSectionSuper TDS Section5020302     Blank194Q5020301     Not BlankClient Section5020303 Fuel vendors   Blank194Q5020302 Fuel vendors   Not BlankClient Section

Last column is my result value