Combine/Consolidate Data

[sagarsangani]

Hello,

I am stuck on a very strange situation. I have my data arranged like this:

Sheet 1

Part # Part Name Comp # Comp Name Quantity
ABC Cell Phone 123 Screen 1
ABC Cell Phone 456 Keys 1
ABC Cell Phone 789 Battery-1 1
XYZ MP3 Player 123 Screen 1
XYZ MP# Player 101 Battery -2 1

Sheet 2
Part # Part Name Comp # Comp Name Quantity
ABC Cell Phone 123 Screen 14
XYZ MP3 Player 123 Screen 14

When I consolidate data, I usually get multiple blank cells. I am not sure how I should merge the data from 2 sheets.