How to group/merge postcodes

Question

Hi&nbsp;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.&nbsp;&nbsp;Example attached&nbsp;&nbsp;Example of what I want:&nbsp;There are about 3000 rows but only approx 450 unique postcodesThanks

sergeibaklan · Answer

SGeorgie&nbsp;
You may create PivotTable like

sgeorgie · Answer

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

sergeibaklan · Answer

SGeorgie&nbsp;
Such form is close to your screenshot

and quite many other variants of PivotTable design

Forum Discussion

How to group/merge postcodes

Share

Resources