Looking for Migration tool

[D R Girish]

Hello..

I have sets of data which needs to be migrated as one...

First data -- The List of Products & the Discount IDs (Here Product codes are unique & each prodcut will have one Discount ID. But Discount IDs are not unique one discount ID can be shared with multiple Product codes)..

Second data -- The Discount IDs list along the multiple quantity ranged sequences tiered discounts..

I need to VBA tool which converts the above data into the Product code with Discount IDs list along the multiple quantity ranged tiered discounts..

Attached the Example file - with the expected resul column in sheet 3..

Hope someone can help to get tool to get this done

Thanks
Girish