Hey everyone,
I hope you are able to help! I am using Excel 2016 + Windows 10.
I am trying to merge two web queries which have three common columns (Date, Campaign Name and Ad Group Name) please see below for the tables and desired outcome. I tried doing a full inner but I end duplicating the common columns.
Thank you in advance!
Table 1
<tbody>
</tbody>
Table 2
<tbody>
</tbody>
Desired Outcome
<tbody>
</tbody>
I hope you are able to help! I am using Excel 2016 + Windows 10.
I am trying to merge two web queries which have three common columns (Date, Campaign Name and Ad Group Name) please see below for the tables and desired outcome. I tried doing a full inner but I end duplicating the common columns.
Thank you in advance!
Table 1
Date | Campaign name | Ad group name | Account Sign Up (All conversions) | Business (All conversions) | Home (All conversions) | Account Sign Up (All conversion value) | Business (All conversion value) | Home (All conversion value) |
07/02/2017 | Brand - New Visitors | Brand - Exact | 4 | 0 | 0 | 4 | 0 | 0 |
07/02/2017 | Brand - New Visitors | Brand - Other | 2 | 0 | 0 | 2 | 0 | 0 |
07/02/2017 | Bulk | Bulk SMS | 2 | 0 | 0 | 2 | 0 | 0 |
07/02/2017 | Bulk | Group Text | 1 | 0 | 0 | 1 | 0 | 0 |
07/02/2017 | Business | Company Text | 1 | 0 | 0 | 1 | 0 | 0 |
07/02/2017 | Business | Business Text | 1 | 0 | 0 | 1 | 0 | 0 |
07/02/2017 | Generic | Text Service | 1 | 0 | 0 | 1 | 0 | 0 |
07/02/2017 | Generic | Send Text | 2 | 0 | 0 | 2 | 0 | 0 |
07/02/2017 | Generic | Send SMS | 1 | 0 | 0 | 1 | 0 | 0 |
07/02/2017 | Generic | SMS Alert | 1 | 0 | 0 | 1 | 0 | 0 |
<tbody>
</tbody>
Table 2
Date | Campaign name | Ad group name | Cost | Impressions | Clicks |
01/06/2017 | Bulk | Bulk SMS | 279.21 | 145 | 10 |
14/06/2017 | Bulk | Bulk SMS | 276.81 | 186 | 8 |
06/03/2018 | Bulk | Bulk SMS | 273.26 | 132 | 9 |
06/12/2017 | Bulk | Bulk SMS | 262.66 | 157 | 12 |
06/06/2017 | Bulk | Bulk SMS | 261.29 | 189 | 9 |
28/04/2017 | Bulk | Bulk SMS | 252.32 | 128 | 12 |
04/12/2017 | Bulk | Bulk SMS | 251.19 | 107 | 8 |
25/04/2017 | Bulk | Bulk SMS | 233.33 | 139 | 10 |
05/06/2017 | Bulk | Bulk SMS | 231.69 | 208 | 7 |
17/05/2017 | Bulk | Bulk SMS | 229.74 | 147 | 12 |
09/02/2018 | Generic | Send SMS | 224.05 | 312 | 20 |
<tbody>
</tbody>
Desired Outcome
<tbody> </tbody> |
<tbody>
</tbody>