Build a query that does a ‘union’ on those fields. in the report add a group by the product name (in example it would p1name) and on the footer add a total for that item.
You could always a where clause if you want to create the report on 1 product.
An example of union is this:
UNION SELECT p4name,p4qty
ORDER BY p1name;