Combining Values in rows and keeping unique values (adv. filtering?)

Hello All,

This is pretty complicating to me. I'm pretty begining at VBA but I'm very sure this requires VBA code. Here's the deal:

I have 5 databases of information that I analyze in Access by Joins of a product number. Each product can have a unique batch number, document number and storage location. Each product also has Order Quanitty values.

What I've done so far is leave out unique values so that I can achieve "sum of order quantity."

I have about 15 different queries and reports searching for different things but the problem is the same. I can't show the unique values without duplicating the product number. For example:

HTML Code: 

In access all I can get is:

HTML Code: 

I know I could export all these to excel then create pivot tables but I'm not going to make 15 privot tables every time I run this report and all of them are different in some way.

What I want is:

HTML Code: 

These reports are about 2,200 rows when I have it with my current problem.

I have Access generating the queries with the DoCmd.TransferSpreadsheet then it also formats the spreadsheets, arranges them for me and names the tabs by report. I'd like it to also do this "Advanced filtering" as well, if possible in Access when exporting to Excel.

Help?