Help me with this please... Urgent..

[geeky]

I have this record
----------------------------------------------
Code | File |
----------------------------------------------
0001 LEX
0002 LEX
0003 QUE


what i want to do is... when there is a duplicate file it will only
show
a FILE and its count... including the Code....
sample output is:

 

[Stopher]

Pivot table with a count column, easiest way I can think of