Macro for making a separate row for two or more clubbed item

[ashwin_bist]

Hi All,

I need to do a vlookup with the order booked report and opportunity created report in CRM.
For this i need to put every order no in different line, i am attaching sheet with a small example. I get some where close to 3k record like this and takes almost 2 days to make the report.

Is any one have any formula whic will do lookup to the two or more order no clubed together or NEED A MACRO WHICH SEPERATE THE ORDER # CLUBBED TOGETHER IN SEPERATE LINE.

Regards
Ashwin