"Jim Thomlinson" wrote in message ...
This can be easily accomplished with a pivot table. Place the cursor anywhere
in the middle of the data you want to consolidate. Choose Data -Pivot Table.
Choose Finish (9 times out of 10 it will make all of the right assumptions
for you.) Drag the "Code" to the right Column. Drag the Value to the Middle.
The country can be plced in a few different spots depending exactly what you
want. Experiment a little.... Pivot tables are kinda fun and really powerful.


Jim,

That works a treat - many thanks