Quickest way would be to add a column to the data so it was organized
as follows:

MONTH | ADVERTISER | STATS

the use a pivot table to summarize by advertiser.



On Jul 29, 8:56*am, potman wrote:

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.