How can i make this:

JUNE 2008
Advertiser Stats
AAB 5
ARL 2
MGM 1
WPC 3
EPM 10

JULY 2008
Advertiser Stats
LFB 7
LCV 8
ARL 3
IGC 5
AAB 1
EPM 3
__________________________________________________ __________________
Into this:

Advertiser June Stats July Stats
XXX XXX XXX
XXX XXX XXX

Note: worksheet contains 10,000 rows, some advertisers in JUNE are not in
JULY stats & vice-versa. what i want to do is consolidate the advertisers in
columnn A without repeating anyone of them with corresponding JUNE & JULY
stats to get the variance per advertiser and i have to do it as fast as i
could to meet the deadline. can anyone help me on this, thanx.