Avatar of axessJosh

asked on 

MS Excel - Word - Merge entire section of data instead of each field independently

I am trying to merge an excel spreadsheet and trying to save some time in the setup.  I have a spreadsheet for a year of church donations.

The spreadsheet is setup in columns as follows:

Donor | Address | City | State | Zip | 1/4/2015 | 1/11/2015 | ... | 12/31/2015

Each donor has a row, but not all donors will have data in each column.

Is there a way to setup the columns for the year of donations as one merge that will display the data that has values or do I need to setup 52 merge fields with If..then..else... rules in my document?

I have looked at PATools, but I think the learning curve is too steep.
Microsoft WordMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment

8/22/2022 - Mon