I need to join 2 tables into 1 combined table in Excel that summarises the data in 1 & 2. Table 3 is noted below as it describes the relationship between 1 and 2.
I have also described a combined table to describe what I would like final data set to look like.
Which Excel functions should be used to join these datasets together?
Table 1
|Campaign|Clicks|Spend|
|Campaign 1|1,000|$50.00|
|Campaign 2|50|$0.90|
Table 2
|Group|Revenue|
|Group 1|$75.00|
|Group 2|$2.50|
|Group 3|$1.00|
Table 3
|Group|Campaign|
|Group 1|Campaign 1|
|Group 2|Campaign 2|
|Group 3|Campaign 1|
Combined Table
|Campaign|Clicks|Spend|Revenue|
|Campaign 1|1,000|$50.00|$76.00|
|Campaign 2|50|$0.90|$2.50|
Table 3
? If it's just alternating you could copy and fill down, but I assume it's more complicated than that?