Combining Vendors

Hello,

Our JDE implementation was done in stages where we added 20 or so companies to JDE over time. When vendors were converted for each of the companies, instead of mapping the vendor data to an existing vendor number each new site's vendors was setup as a new vendor. Because of this we of course now have multiple vendor numbers for the same vendor. We would like to combine these but there is no Oracle delivered way to accomplish this. The question is if anyone has had to do this before? If so, what would be the best way to approach?