How to combine two worksheets into one. Only ONE column is common.
 

Hello everyone. In advance, thanks for your help.

I have two worksheets in one workbook. Only one column is common between
both worksheets - this column contains data for Part Numbers from one source.
The second sheet contains data for these Part Numbers from another source -
but not all Part Numbers are represented within this worksheet.

What is the fastest way to combine the data within both worksheets into ONE
worksheet? I want all Part Numbers to be contained, whether there is data
from the second worksheet or not.

Thank you SO MUCH for your help.