Group Data by geographical Area

[danturv]

Hi,

I have some data with column of town names (40k rows with around 500 unique towns). Is it possible to group the data by a geographical area i.e Northern or Southern area?

Thanks for any help offered

 

[alansidman]

Show us a small sample of what your workbook looks like

 

[danturv]

AB24 5	Aberdeen	21.8	2.1	0	0	0	0	LOW
AB24 5	Aberdeen	22.1	10.2	0	2	0	2	HIGH
AB24 5	Aberdeen	22.2	5.1	0	1	0	1	MEDIUM
AB24 5	Aberdeen	22.2	10.1	0	2	0	2	HIGH
B1 1	Birmingham	28.9	5.5	0	1	0	1	MEDIUM
B1 1	Birmingham	28.9	0	0	0	0	0	LOW
B1 1	Birmingham	28.9	12.9	0	2	0	2	HIGH
CB1 0	Cambridge	45.2	0.0	0	0	2	2	HIGH
CB1 0	Cambridge	45.4	0.0	0	0	0	0	LOW
CB1 0	Cambridge	45.4	0	0	0	0	0	LOW
CB1 0	Cambridge	45.5	0.0	0	0	0	0	LOW
CB1 0	Cambridge	45.5	7.5	0	1	0	1	MEDIUM
BH15 1	Poole	23.1	10.2	0	2	0	2	HIGH
BH15 1	Poole	23.1	0	0	0	0	0	LOW
BH15 1	Poole	23.1	3	0	0	0	0	LOW
BH15 1	Poole	23.2	5.5	0	1	0	1	MEDIUM

<colgroup><col style="width:62pt" width="83" span="9"> </colgroup><tbody>
</tbody>

 

[alansidman]

Which field distinguishes the geographic area? What is the criteria for grouping? If you were to do this manually, what would it look like?

 

[danturv]

The geographical area can be distiguished by column 1 (UK Postcode) or column 2 (UK Town). Ideally I would like to be able to see the percentage of High, Medium or Low risk (column 9) by area (possibly user defined) such as Scotland, North England, Middle England and South England though I am guessing that this would need to be done with some kind of mapping link?

Thanks