Hello all,

I'm trying to bring together two sets of data that use a numbered "provider ID" to designate a given hospital, like below.
Screen Shot 2013-08-08 at 5.07.24 PM.png

The problem is that, while there is overlap between my two datasets, they don't match. That is, some hospitals are on both lists and some are only on one or the other.

I had wondered about adding rows whenever a number is missing (so, one each for 10002 thru 10005 in the example above). Then I could combine my data and filter out the blanks.

Any thoughts on formulae or VB to accomplish this would be greatly appreciated.

Thank you!