I've got a list from a heating company who services customer's and
keeps their list by item (ie: air conditioner, heater, etc) so the
customer id's are the same for each customer, but there are multiple
rows for each customer. In order to do a mail merge and have all of
the customer data be the same (to do billing), everything needs to be
on the same line. The consistant data is their name, address,
customer id. Variable data is the amount owed, item serviced, make
and model number. How do I go about doing this?