Merge Values

[billym007]

I am totally lost with this one and not sure if it can be done.

I have a list of customer account codes which buy a certain product from me and then on sheet two i have a second list of account codes who buy a different product from me. There are some accounts code on both sheets which buy both products

I want to merge the two sheets together so i have a full list, therefore giving me one list like

Customer Code Product a Product b
1234 £126,44 £12.54
2345 n/a £347.65

Is this possible as i have over 5000 customer codes

 

[Robert Mika]

You can try to copy both sheets in another sheets so you will get 10000 rows and then to use Advance Filter to copy unique values to diffrent location.