Excel/Word Mail Merge - Same Address...different names/Rows
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...
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
Desired Result:
Mr. Tom Brady and Mrs. Gisele Bundchen
6 Patriots Road
Foxboro, MA 02035
Thanks!
|