Checking data in different formats

I have two sheets I want to compare to see if all the data in one is in the other. However they are set up different. They are accounts of wholesale ice cream sales, and there are 6 total products: 3 flavors (choc., van., straw.) and 2 sizes (qt., pt.). Each customer buys some combination of the 6 products (most buy at least 1 of each but that's not guaranteed)

The first sheet has the following columns:
Customer Name
Choc. pt.
Van. pt.
Straw. pt.
Choc. qt.
Van. qt.
Straw. qt

Each row contains a new unique customer and the quantity of each ice cream tub that they buy.


The second sheet has the following columns:
Customer Name
Flavor
qt.
pt.

Each row in this sheet has a customer name with a flavor (either Choc., Van., or Straw.) and then the quantity of each tub size that they buy. In this case, a customer name can be repeated up to three times if they buy some of all three flavors.


How can I manipulate this data so that I can make sure these two sheets are recording the same information. There are lots of instances, so a macro or a function would be ideal. How can I do this? Any insight is very appreciated!

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.