Create Invoices using multiple Lines Follow

Hello,

Essentially what we are wanting to do is create an invoice for our customers using bartender, the Document will have the Reference number, Delivery address and the Item and item description which is read from each individual line.

Although using the SQL query that we have it pulls back three separate lines for each item

The first 2 Lines are customer 1 and the second line is customer 2.

Lines Example

Line 1  - CP1Address1,CP1Address2,CP1Address3,CP1Address4, CP1Postcode, Item1, Item1 Description, Reference

Line 2  - CP1Address1,CP1Address2,CP1Address3,CP1Address4, CP1Postcode, Item2, Item2 Description, Reference

Line 3  - CP2Address1,CP2Address2,CP2Address3,CP2Address4, CP2Postcode, Item1, Item1 Description, Reference

How can we create a document where Line 1,2 are on the same document and a separate documents is create on Line 3 for its own separate Invoice.

We have tried using the page template to create multiple labels on one page but we are unable to separate the third line onto a new document.

Any recommendations would be highly appreciated.

Thanks