Hi,

I have an excel file with the following details:

Invoice No. Item Code Amount
490502688
117363
589.00
490502688
117380
713.00
490502689
117380
125.00
490502692
69384
105.00
490502692
105009
735.00
490502692
116531
35.00
490502692
161556
846.00


I need to prepare a Mail Merge of over 100 invoices. Each invoice may have 1 or more item codes. But the mail merge should make the 2nd item to appear on a row below the 1st item if there are more than 1 items against an invoice number.

For example: Invoice Number has 2 item codes against it. So the mail merge automated invoice template should display both the items one below the other along with the amount.