Separate and align rows from two separate sheets based on a cell value.

Hello and thank you for any assistance you can provide.

In the attached file, I have two sheets with data: Internal Source Data, and Outside Source Data.

I have a tab titled Desired Result, which illustrates the end result I'm trying to achieve - which is basically to take the date from the Internal and Outside Source Data sheets, separate and align them based on the Unique ID.

I have issues using Vlookup or Index/Match, because the amounts of rows for each Unique ID are not always congruent.

Also, I have a macro (thank you jindon!) which fills in formulas in rows J through L. I can get them to populate in the appropriate areas, but the formulas are returning 0. I'm not sure what I'm missing there.

Furthermore, is this something that is better handled by a Pivot Table, or some other means?

That is most impressive! A few questions, forgive me:

Does this code assume that each Unique ID is represented in both sets of data?

Also, if I were to replace one of the columns with text, will that affect the functionality? I assume if I wanted to add columns to the data sets, I would just add another:

Please Login or Register  to view this content.

And then adjust the following to account for the new column:

Please Login or Register  to view this content.

Lastly, is there a limit to the amount of rows this will search and match? I assume row counts approaching or exceeding 1000 would take a long time to calculate?

Thanks again JBeaucaire!