Comparing and sorting multiple column groups

So I would appreciate any help that I could get here. I'm am trying to take multiple column-groups and sort them by product ID number.

I am trying to put together a sales record for the past 26 months for around 2000 different items and sorting them manually would obviously be a nightmare.

I would like to sort them so that all the drugs with the same NDC (prod ID) have the correct data for each month displayed on the correct row for that NDC. Right now I have each set of data for that month sorted by product ID number but some months we used certain products and others we did not. Is there any sort of Macro that I could use? To give you an idea of what I am trying to do I attached two files. The "before" and my desired "after".

Thanks to anyone who can help.

starting point.xlsx
end product.xlsx