2 dates in different tables with no link

[delbooth]

Hi.

I have two tables.  Table 1 has collection data such as weight, date collected.  Table 2 has dispatch data such as dispatch weight and dispatch date.

I want put both into a table but there is no link in the data between the two tables such that you get

Month  Weight collected  Weight Dispatched

Jan               10                         15

Feb               12                         24

Thanks

Del

[OmarBenSalem]

U can link them by date?

Or, use canonical dates

please refer tio this:

Canonical Date