Merging and Joining Tables

Greets Community,

My goal is to do a comparison table.

  • I have 1 google sheet with 3 tabs.
  • Each tab as the same column names. (ex: position, total impressions, CTR…. etc)
  • Rows vary slightly depending on the test we performed

What I was interested in doing is:

Position | Total Impressions (test1) | Total Impressions (test2) | Total Impressions (test3)

Is that possible? I tried multiple times but couldn’t get this to work. Each time I do a join and pull in the data column it duplicates itself.

Not sure what I’m doing wrong.

Any help would be much appreciated.

Rurth