Line up set of data when one is incomplete?

Hi all,

I do this manually now and it's a pain in the butt so I'm hoping someone can help me automate this.

I basically have two sets of data. To make it simple let's say it looks like this:

Please Login or Register  to view this content.

What I want to do is go through the set that's missing data and have it end up so that the order numbers are lined up with the first set to I can easily tell which ones are missing.

So I'd like the end result to look like:

Please Login or Register  to view this content.

Can anyone help me with this?

The data sets might change so there might be anywhere from 3 columns to 6-7 columns per set but I can change that as it comes. Also then the columns that have the matching data would also be in different places but I can change that too.

Thanks for any help!

Assuming the order will always be the same, you could use this:

Please Login or Register  to view this content.