Forum Discussion
Ankit Patel
Oct 15, 2018Copper Contributor
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.
Hi Ankit,
Not sure about VBA sample, but Power Query could do the work.