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.