I am a banking officer and have following sort of data:
A B C D E F
CLIENT CASH CREDIT CHEQUE VISA
A 3,677 CASH
B 5,946 3,942 CASH/CHEQUE
C 8,939 4,237 CREDIT/VISA
D 2,040 VISA
E 1,000 6,070 CREDIT/CHEQUE
F 6,374 CASH

I want a formula in column F showing results as above. In other words,
reflecting only the mode(s) of payment used as labeled on the first row with
"/" inserted in between if there is more than two modes.

Please do keep in mind that actual data is comprising numerous columns.

All help is appreciated.
--

Best Regards,
FARAZ A. QURESHI