Greetings all,

A friend is producing a report for different countries showing what diseases exist in each country. I think a mail merge might work, but we will want to list information only about diseases that are present in a given country. Right now, we have blank / null cells in our Excel spreadsheet for non-present diseases. Each disease has a handful of related variables, some of which contain info specific to the countries. Essentially, we’d like to collapse the display of any missing data fields (and its accompanying table) so that only relevant data is shown. So if we had three diseases total (A, B, C) and only two were present in a country (A & C), we’d like to produce:

Table. Disease A
Info, data in table

Table. Disease C
Info, data in table

How might I accomplish this with Word? Any ideas? Many thanks in advance for the help!

Sincerely,
Eric

Edit: Another way of asking the question might be: how could I hide empty tables automatically in Word? These reports will be printed out to PDFs.