The above two input tables have the Shipment Data and Receipt Data respectively. The objective is to tie these two data together to appear like the below Output table. Each Shipment has a...

The above two input tables have the Shipment Data and Receipt Data respectively. The objective is to tie these two data together to appear like the below Output table. Each Shipment has a corresponding Receipt, but not necessarily on the same day. For example, Shipment 10002 that was shipped on 2/5/2015 from RDC to Store 2 has a Receipt Date of 2/6/2015. The total number of shipments for a given RDC – Store combination is equal to the total number of receipts for the same combination.

Hint – Assume the shipment were received in the order they were shipped. In cases where there were 2 Receipts for the same store on the same day, randomly assign the shipments to the 2 receipts.