Compare and Merge Data with different columns in two diffrent sheets

Hello,

I need to make one file out of these two attached here. Thing is there is not a single same column in both, so on what bases I can compare these two?

Final File should have only one column with Url and all other column field values  (from Both) related to that particular column. 

ex: 

Column 1. www.xyz.com/ , keyword , Pos, +/- , Se.Vol, CPC, Competitor , Pageviews, Unique,Ave.Time,Entrances..

Is there any VBA example available for this?

Thanks.