Merging data into pivot tables
 

I need to merge or consolidate data from two worksheets into one worksheet.
Worksheet A includes data in a table format; Worksheet B includes data in
pivot table format. Product part numbers are common on both spreadsheets and
I need to compare data that our customer has against what we have. Is it
possible to do this without coverting one of the data sets into the same
format as the other data set?