Thank you for the response! I have tried several variations of this method based on the pinned tips and tricks. It is still problematic in the event the all the evaluations have >0 values or not. I have tried the method you purpose and have also tried to nest the IF statements, but I am ending up with values on the same line or still some with line breaks.
My data is
CAT1 CAT1Value CAT2 CAT2Value CAT3 CAT3Value CAT4 CAT4Value
desc1 $10.00 desc2 $0.00 desc3 $15.00 desc4 $20.00
desc1 $10.00 desc2 $10.00 desc3 $0.00 desc4 $0.00
desc1 $0.00 desc2 $20.00 desc3 $0.00 desc4 $0.00
desc1 $20.00 desc2 $3.00 desc3 $10.00 desc4 $10.00
desc1 $10.00 desc2 $0.00 desc3 $0.00 desc4 $10.00
I am trying to get the first row evaluation to write:
desc1
desc3
desc4
unless I am misunderstanding your recommendation, the results are
desc1
desc3desc4
|