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!

In addition, how do I insert a table ONLY when one of the products has information. So if Product D has a % in the data source then insert a table that will have three columns headers : Product, Current Price, New Price.

This table will only show when Product D has a % otherwise it will be "invisible".

The table will have 11 rows. Each of those "cells" will be conditioned "show" when Product D has a % in the data source.

Product Current Price New Price
Fee 1 $1.00 $2.00
Fee 2 $2.00 $3.00
Fee 3 $3.00 $4.00

Thanks again!!!!!