Thank you, thank you, thank you for you quick response during the weekend. I was having computer problems so I was unable to thank you right away.
It seemed to have worked with the products that had values listed one after the other on one line. I ventured into adding a ¶ after each product mergefield so that the products appear one over the other, but in doing so I get an empty row that I don't need/want...how do I get rid of those blank rows or how do I get the results to list without empty product lines?
This is the edited version for Products A-C taking your formula and adding the extra ¶
{ IF { MERGEFIELD "Product A" } <> "" "Product A : { MERGEFIELD "Product A" }¶" }¶{ IF { MERGEFIELD "Product B" } <> "" "Product B : { MERGEFIELD "Product B" }¶" }¶{ IF { MERGEFIELD "Product C" } <> "" "Product C : { MERGEFIELD "Product C" }¶" }¶
So right now I get the following look:
Product A #%
Product C #%
Product D #%
I want to eliminate that extra empty row that pertains to Product B (which didn't populate because it didn't have a value....which is what I wanted/needed)
Thanks in advance!