I have a column that pulls data from multiple cells to form an event description. But I would like to add some conditions to hide stuff with " " that doesn't have any information in the cell. I am not sure how can I use an IF condition within an IF within an Array formula.
=ArrayFormula(
IF(ROW(AR:AR)=1,"Description",
IF(ISBLANK(AR:AR),"",
IF(LEN(A:A),"Supplier
"&I:I&" - "&J:J&" : "&K:K&""&L:L&"MT
"&M:M&" - "&N:N&" : "&O:O&""&P:P&"MT //Hide "-" ":" "MT" or the entire line if there is no 2nd Supplier
"&Q:Q&" - "&R:R&" : "&S:S&""&T:T&"MT //Hide "-" ":" "MT" or the entire line if there is no 3rd Supplier
Remarks "&U:U&" //Hide the entire line if there are no remarks
Agent "&W:W&" "&X:X&" "&Y:Y&"
Lab "&V:V,""
))))
Currently the result below where there are no 2nd & 3rd supplier is not very ideal.
Supplier
CHEVRON - 12345678 : AAE500CST1900MT
- : MT
- : MT
Remarks
Agent Avenger Steven 88888888
Lab
Aucun commentaire:
Enregistrer un commentaire