Beginners question, how to link two datasets which both contain sales data?

monaldo12

New Member
Joined
Mar 17, 2016
Messages
45
I have these two datasets that I want to link together.
Dataset 1 contains column units sales by specific EAN and Etailer in a specific week.
Dataset 2 contains customer ( = etailer), SAP sku (=EAN) and month (=actually week data as is dataset 1), unit sales sell in.

I want to combine this to one data source, do I need to make a specific key in both datasets to link them together and what would that be?

dataset 1:
1680873907192.png


dataset 2:
1680874150438.png
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Please update your profile to indicate what version of Excel you're using and what OS. Also, please post data using XL2BB rather than screenshots, and more than just the header.
As for your question, one of the two tables has to have a column (or combination of columns) whose values are unique. Which table (dataset) are you looking to pull information into?
 
Upvote 0

Forum statistics

Threads
1,223,248
Messages
6,171,027
Members
452,374
Latest member
keccles

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top