Here is my table for sheet1:

Shipment No. Product No. of Pieces
A pencil 1
B pen 1
A eraser 1
A paper clip 2
B stamp 3
C ruler 1
B calculator 2

I am trying to create a new table in a new sheet (sheet2) that will list all
the products and pieces that were part of shipment no. A

This is what I would like it to look like

Product No. of Pieces
pencil 1
eraser 1
paper clip 2

How do I go about doing this? Please help!