It starts with the formatting of your source data. If you need it four-up, you need your data the same way.
Column 1 – Name Column 2 – Street Column 3 – City/State Column 4 – Zip Column 5 – Name(2) Column 6 – Street(2), etc…..
So if you do four-up on a sheet, you’ll need four sets of data going across in your columns.
https://i99.photobucket.com/albums/l305/Technical_Terry/merge.gif
Tech-T Productions
http://www.technical-t.com
ps-None of my comments are meant to be gospel. Otherwise, I would write a book that provided all the cold, hard, fast answers that everyone assumes are out there. These are the things that I have found to work well with my shooting habits and workflow. Always try things out for yourself and deduce the best workflow for you.