Populating Tables with data when available only - Using Mail merge
Hi,
I am trying to create a table where I show the Name of the PORTFOLIO on one column, the ASSET CLASSES on the second column and TARGET value for each asset class.
I have attached the data, and the output I want from a mail merge on a word document.
The challenge I have with my data is some PORTFOLIOS do not have all the ASSET CLASSES and their TARGET VALUE. How can I run a mail merge in a way that the table will not show ASSET CLASSES with ZERO values?
If you see the excel spreadsheet you will understand what I am referring to.
How can I overcome this to effectively carry out a mail merge as shown in the output sheet?
Thanks!
John
|