Hi Everyone!
Below is the Row 1 is a commodity and in row 2 is the number of pallets. Anything that more than "0" the commodity will appear in "Output" but with "/" as a separator in each commodity, which I do not know what formula would it be? Thanks in advance.
=CONCATENATE(IF(A2>0,"BREAD",""),IF(B2>0,"FROZEN",""),IF(C2>0,"WATER",""),IF(D2>0,"FFV",""))
<tbody>
</tbody>
Below is the Row 1 is a commodity and in row 2 is the number of pallets. Anything that more than "0" the commodity will appear in "Output" but with "/" as a separator in each commodity, which I do not know what formula would it be? Thanks in advance.
=CONCATENATE(IF(A2>0,"BREAD",""),IF(B2>0,"FROZEN",""),IF(C2>0,"WATER",""),IF(D2>0,"FFV",""))
BREAD | FROZEN | WATER | FFV | TOTAL | OUTPUT |
2 | 2 | 2 | 5 | 11 | BREAD/FROZEN/WATER/FFV |
<tbody>
</tbody>