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
[TABLE="width: 2258"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Campaign name[/TD]
[TD]Ad group name[/TD]
[TD]Account Sign Up (All conversions)[/TD]
[TD]Business (All conversions)[/TD]
[TD]Home (All conversions)[/TD]
[TD]Account Sign Up (All conversion value)[/TD]
[TD]Business (All conversion value)[/TD]
[TD]Home (All conversion value)[/TD]
[/TR]
[TR]
[TD="align: right"]07/02/2017[/TD]
[TD]Brand - New Visitors[/TD]
[TD]Brand - Exact[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]07/02/2017[/TD]
[TD]Brand - New Visitors[/TD]
[TD]Brand - Other[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]07/02/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]07/02/2017[/TD]
[TD]Bulk[/TD]
[TD]Group Text[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]07/02/2017[/TD]
[TD]Business[/TD]
[TD]Company Text[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]07/02/2017[/TD]
[TD]Business[/TD]
[TD]Business Text[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]07/02/2017[/TD]
[TD]Generic[/TD]
[TD]Text Service[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]07/02/2017[/TD]
[TD]Generic[/TD]
[TD]Send Text[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]07/02/2017[/TD]
[TD]Generic[/TD]
[TD]Send SMS[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]07/02/2017[/TD]
[TD]Generic[/TD]
[TD]SMS Alert[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]
Table 2
[TABLE="width: 1034"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Campaign name[/TD]
[TD]Ad group name[/TD]
[TD]Cost[/TD]
[TD]Impressions[/TD]
[TD]Clicks[/TD]
[/TR]
[TR]
[TD="align: right"]01/06/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]279.21[/TD]
[TD="align: right"]145[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]14/06/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]276.81[/TD]
[TD="align: right"]186[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]06/03/2018[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]273.26[/TD]
[TD="align: right"]132[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]06/12/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]262.66[/TD]
[TD="align: right"]157[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]06/06/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]261.29[/TD]
[TD="align: right"]189[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]28/04/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]252.32[/TD]
[TD="align: right"]128[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]04/12/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]251.19[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]25/04/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]233.33[/TD]
[TD="align: right"]139[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]05/06/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]231.69[/TD]
[TD="align: right"]208[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]229.74[/TD]
[TD="align: right"]147[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]09/02/2018[/TD]
[TD]Generic[/TD]
[TD]Send SMS[/TD]
[TD="align: right"]224.05[/TD]
[TD="align: right"]312[/TD]
[TD="align: right"]20[/TD]
[/TR]
</tbody>[/TABLE]
Desired Outcome
[TABLE="width: 1034"]
<tbody>[TR]
[TD][TABLE="width: 1466"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Campaign name[/TD]
[TD]Ad group name[/TD]
[TD]Cost[/TD]
[TD]Impressions[/TD]
[TD]Clicks[/TD]
[TD]Account Sign Up (All conversions)[/TD]
[TD]Business (All conversions)[/TD]
[TD]Home (All conversions)[/TD]
[TD]Account Sign Up (All conversion value)[/TD]
[TD]Business (All conversion value)[/TD]
[TD]Home (All conversion value)[/TD]
[/TR]
[TR]
[TD="align: right"]01/06/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]279.21[/TD]
[TD="align: right"]145[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]14/06/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]276.81[/TD]
[TD="align: right"]186[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]06/03/2018[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]273.26[/TD]
[TD="align: right"]132[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]06/12/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]262.66[/TD]
[TD="align: right"]157[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]06/06/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]261.29[/TD]
[TD="align: right"]189[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]28/04/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]252.32[/TD]
[TD="align: right"]128[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]04/12/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]251.19[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]25/04/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]233.33[/TD]
[TD="align: right"]139[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]05/06/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]231.69[/TD]
[TD="align: right"]208[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]229.74[/TD]
[TD="align: right"]147[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 2258"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Campaign name[/TD]
[TD]Ad group name[/TD]
[TD]Account Sign Up (All conversions)[/TD]
[TD]Business (All conversions)[/TD]
[TD]Home (All conversions)[/TD]
[TD]Account Sign Up (All conversion value)[/TD]
[TD]Business (All conversion value)[/TD]
[TD]Home (All conversion value)[/TD]
[/TR]
[TR]
[TD="align: right"]07/02/2017[/TD]
[TD]Brand - New Visitors[/TD]
[TD]Brand - Exact[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]07/02/2017[/TD]
[TD]Brand - New Visitors[/TD]
[TD]Brand - Other[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]07/02/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]07/02/2017[/TD]
[TD]Bulk[/TD]
[TD]Group Text[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]07/02/2017[/TD]
[TD]Business[/TD]
[TD]Company Text[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]07/02/2017[/TD]
[TD]Business[/TD]
[TD]Business Text[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]07/02/2017[/TD]
[TD]Generic[/TD]
[TD]Text Service[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]07/02/2017[/TD]
[TD]Generic[/TD]
[TD]Send Text[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]07/02/2017[/TD]
[TD]Generic[/TD]
[TD]Send SMS[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]07/02/2017[/TD]
[TD]Generic[/TD]
[TD]SMS Alert[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]
Table 2
[TABLE="width: 1034"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Campaign name[/TD]
[TD]Ad group name[/TD]
[TD]Cost[/TD]
[TD]Impressions[/TD]
[TD]Clicks[/TD]
[/TR]
[TR]
[TD="align: right"]01/06/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]279.21[/TD]
[TD="align: right"]145[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]14/06/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]276.81[/TD]
[TD="align: right"]186[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]06/03/2018[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]273.26[/TD]
[TD="align: right"]132[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]06/12/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]262.66[/TD]
[TD="align: right"]157[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]06/06/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]261.29[/TD]
[TD="align: right"]189[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]28/04/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]252.32[/TD]
[TD="align: right"]128[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]04/12/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]251.19[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]25/04/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]233.33[/TD]
[TD="align: right"]139[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]05/06/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]231.69[/TD]
[TD="align: right"]208[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]229.74[/TD]
[TD="align: right"]147[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]09/02/2018[/TD]
[TD]Generic[/TD]
[TD]Send SMS[/TD]
[TD="align: right"]224.05[/TD]
[TD="align: right"]312[/TD]
[TD="align: right"]20[/TD]
[/TR]
</tbody>[/TABLE]
Desired Outcome
[TABLE="width: 1034"]
<tbody>[TR]
[TD][TABLE="width: 1466"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Campaign name[/TD]
[TD]Ad group name[/TD]
[TD]Cost[/TD]
[TD]Impressions[/TD]
[TD]Clicks[/TD]
[TD]Account Sign Up (All conversions)[/TD]
[TD]Business (All conversions)[/TD]
[TD]Home (All conversions)[/TD]
[TD]Account Sign Up (All conversion value)[/TD]
[TD]Business (All conversion value)[/TD]
[TD]Home (All conversion value)[/TD]
[/TR]
[TR]
[TD="align: right"]01/06/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]279.21[/TD]
[TD="align: right"]145[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]14/06/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]276.81[/TD]
[TD="align: right"]186[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]06/03/2018[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]273.26[/TD]
[TD="align: right"]132[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]06/12/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]262.66[/TD]
[TD="align: right"]157[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]06/06/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]261.29[/TD]
[TD="align: right"]189[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]28/04/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]252.32[/TD]
[TD="align: right"]128[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]04/12/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]251.19[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]25/04/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]233.33[/TD]
[TD="align: right"]139[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]05/06/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]231.69[/TD]
[TD="align: right"]208[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]17/05/2017[/TD]
[TD]Bulk[/TD]
[TD]Bulk SMS[/TD]
[TD="align: right"]229.74[/TD]
[TD="align: right"]147[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]