doucecool57
New Member
- Joined
- Mar 20, 2013
- Messages
- 8
Not sure if more of an excel question or a Word Question but here is my issue. We use an EHR where the contact report that is exported has every contact separated into their own row in excel...
for example: mom and dad, living in the same house, have separate entries in the form and are on their own rows within the excel report. I would like to combine mom and dad on one address block for an envelope so they do not receive two invitations to the same event...
<colgroup><col width="160" span="7" style="width:120pt"></colgroup><tbody></tbody>
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Desired Result:
Mr. Tom Brady and Mrs. Gisele Bundchen
6 Patriots Road
Foxboro, MA 02035
Thanks!
for example: mom and dad, living in the same house, have separate entries in the form and are on their own rows within the excel report. I would like to combine mom and dad on one address block for an envelope so they do not receive two invitations to the same event...
<colgroup><col width="160" span="7" style="width:120pt"></colgroup><tbody></tbody>
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Prefix | First Name | Last Name | Address | City | State | Zip |
Mr | Tom | Brady | 6 Patriots Road | Foxboro | MA | 02035 |
Mrs. | Gisele | Bundchen | 6 Patriots Road | Foxboro | MA | 02035 |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Desired Result:
Mr. Tom Brady and Mrs. Gisele Bundchen
6 Patriots Road
Foxboro, MA 02035
Thanks!