please can someone offer a suggestion as to how to normalise the following table comprising of british regions,postcodetowns
& posttowns as columns
region postCodeTown postTown
MIDLANDS1 BIRMINGHAM BIRMINGHAM
MIDLANDS1 BIRMINGHAM ALCESTER
MIDLANDS1 BIRMINGHAM BROMSGROVE
..... ......
MIDLANDS1 COVENTRY COVENTRY
MIDLANDS1 COVENTRY ATHERSTONE
MIDLANDS1 COVENTRY BEDWORTH
..... ......
MIDLANDS1 DUDLEY DUDLEY
MIDLANDS1 DUDLEY BEWDLEY
MIDLANDS1 DUDLEY BRIERLEY HILL
..... .....
..... .....
MIDLANDS2 DERBY DERBY
MIDLANDS2 DERBY ALFRETON
..... .....
thanking you in advance
paul
<!-- e --><a href="mailto[email protected]">[email protected]</a><!-- e -->
& posttowns as columns
region postCodeTown postTown
MIDLANDS1 BIRMINGHAM BIRMINGHAM
MIDLANDS1 BIRMINGHAM ALCESTER
MIDLANDS1 BIRMINGHAM BROMSGROVE
..... ......
MIDLANDS1 COVENTRY COVENTRY
MIDLANDS1 COVENTRY ATHERSTONE
MIDLANDS1 COVENTRY BEDWORTH
..... ......
MIDLANDS1 DUDLEY DUDLEY
MIDLANDS1 DUDLEY BEWDLEY
MIDLANDS1 DUDLEY BRIERLEY HILL
..... .....
..... .....
MIDLANDS2 DERBY DERBY
MIDLANDS2 DERBY ALFRETON
..... .....
thanking you in advance
paul
<!-- e --><a href="mailto[email protected]">[email protected]</a><!-- e -->