Simple transaction >> Mail Merge >> Invoice

[eyz4eva]

I am trying to create excel database for my simple home business.

The current spreadsheet is as such

Products Table:
Product | Price

Cust Table:
Cust Name | Address | Contact No.

Order:
Cust Name | Product | Qty | Product | Qty | Product | Qty

Eg:

Mary | Fish | 5 | Chicken | 2 | Beef | 3
Ann | Fish | 2 | Chicken | 4
Jack | Fish | 10
Ken | Chicken | 5 | Beef | 2

With this entry format, it is very easy for me to use MS Word to mail merge into multiple invoices.

However, the cons is that this is not a proper format for database entry. Hence the suggested entry format would be as below.

Mary | Fish | 5
Mary | Chicken | 2
Mary | Beef | 3
Ann | Fish | 2
Ann | Chicken | 4
Jack | Fish | 10
Ken | Chicken | 5
Ken | Beef | 2

However, I do not know how to generate these data into invoice format. Hope I can get some help here.

1) Should I transpose/generate the data back to

Order:
Cust Name | Product | Qty | Product | Qty | Product | Qty

2) Is there any way to create multiple invoices from the excel program?

There are some paid program out there The easiest Mail Merge with Edi-Texteditor FREE and Simple Sheets | Premium Excel Package and it might serves what I need. However, I'm just a small home based business and can't really afford to pay for it. Really hope someone can help me.

 

[eyz4eva]

hope someone can take a look.