View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Joerg Mochikun Joerg Mochikun is offline
external usenet poster
 
Posts: 104
Default consolidating data

You could add columns for Year and Month, copy values into new columns,
remove all blank lines and surplus headers. The result would look like this:
Advertiser Stats Year Month
AAB 5 2008 June
ARL 2 2008 June
MGM 1 2008 June
WPC 3 2008 June
EPM 10 2008 June
LFB 7 2008 July
LCV 8 2008 July
ARL 3 2008 July
IGC 5 2008 July
AAB 1 2008 July
EPM 3 2008 July


Now use pivot tables to do you analysis.

Cheers,

Joerg Mochikun


"potman" wrote in message
...
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.