Plot UK postcodes on map for sales team territories

[Limbo1964]

Hi,

I would like to plot UK postcodes onto a map to show where each sales person has customers.

I have a number of columns all filled with individual postcodes. One column for each rep.

I would like the postcodes in each column to be plotted on the graph with a different colour for each column to signify each rep.

Can this be done?

Sample data below.

KM	NM	JD	MF	MH	AA
BL5 3QR	BD21 4LA	BH17 0RB	BL3 3WW	CH7 4TG	BL1 8HU
BL6 5GR	BD21 5JU	BH17 0RS	BL9 7BR	CH8 7EL	BL2 6DW
BL7 0FS	BD4 8SJ	BH21 3SN	BN2 6AH	CH8 9HE	BN15 8SU
BL9 7HT	CV37 8LL	BH21 6RR	BT2 7FE	CH8 9HE	BN15 8TU
BT79 9LZ	CV8 3DX	BH21 7JX	BT35 6JQ	DH7 8HJ	BN18 0HY

[v-yulgu-msft · Accepted solution]

Hi @Limbo1964,

In Query Editor mode, unpivot all columns. Press Ctrl key, select all columns, then, click the "Unpivot Columns" button.

Rename the new columns (in my test, it's [rep] and [postal code]) and save the changes. In data view mode, create a map like below.

Best regards,
Yuliana Gu