<div>
<div class="content wysiwyg-content">
I am trying to merge an excel spreadsheet and trying to save some time in the setup. &nbsp;I have a spreadsheet for a year of church donations.<br />
<br />
The spreadsheet is setup in columns as follows:<br />
<br />
Donor | Address | City | State | Zip | 1/4/2015 | 1/11/2015 | ... | 12/31/2015<br />
<br />
Each donor has a row, but not all donors will have data in each column.<br />
<br />
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?<br />
<br />
I have looked at PATools, but I think the learning curve is too steep.
</div>
</div>


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.

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

Microsoft Word is a commercial document editing program that is part of the Microsoft Office suite. It features numerous text-editing tools for creating richly formatted documents, along with tools for the use of macros in Word documents. Word's native file formats are denoted either by a .doc or .docx file extension. Plugins permitting the Windows versions of Word to read and write formats it does not natively support, such as the OpenDocument format (ODF) are available. Word can import and display images in common bitmap formats such as JPG and GIF. It can also be used to create and display simple line-art.

Microsoft Word

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.