Hi there,

I have been working with Excel in different formats for several years but can't seem to find a short hand way of carrying out a long hand task.

Basically I have to compile some figures from various different teams, the data comes in a standard way however although the codes used by different teams vary, they are all from the same standard list. I copy paste all the information into one sheet but then need to summarise it. The copy paste into the sheet looks something like this: (though there is usually a larger amount of data.

A B C D E F G H
1 Jan Feb Mar Apr
2 CC01 12 CC01 23 CC03 82 CC02 20
3 CC02 46 CC04 14 CC04 15 CC03 04
4 CC07 52 CC05 26 CC06 12 CC06 01
5 CC08 22 CC08 19 CC07 08 CC08 11

I need it to look somthing like this: (Apologies for the not quite exact formatting.

A B C D E F
1 Code Jan Feb Mar Apr Total
2 CC01 12 23 0 0 35
3 CC02 46 0 0 20 66
4 CC03 0 0 82 04 86
5 CC04 0 14 15 0 29
6 CC05 0 26 0 0 26
7 CC06 0 0 12 01 13
8 CC07 52 0 08 0 60
9 CC08 22 19 0 11 52

I know how to total the rows automatically, its a case of sifting through the data to get a difinitive list of all codes used.

Any help would be grately appreciated.

Many thanks

C