How to group/merge postcodes

[SGeorgie]

Hi

i have a list of addresses and I'd like to group all the same postcodes together so that I can see how many properties I have under each postcode. How can i quickly and esasily do this. 

Example attached

Example of what I want:

There are about 3000 rows but only approx 450 unique postcodes

Thanks

[#2]

@SGeorgie 

You may create PivotTable like

[#3]

Thanks I tried a pivot but I want a more condenssed view as there will be over 450 postcodes,

[#4]

@SGeorgie 

Such form is close to your screenshot

and quite many other variants of PivotTable design