Filled Map for multiple locations

[Randqaq]

Hello 

I have the below set of data (sample):

I want to create a filled map and allow all locations associated with each project to be highlighted at the same time once a project is selected. 

Please advise how to do this?

Project	City 1	City 2
X	Amman	Zarqa
Y	Balqa	Madaba
z	Fuhais	Amman

[Anonymous]

Hi @Randqaq 

You should try to Pivot your data (columns City 1 and City 2) to get something like that:

And then you create the filled map with "Project" as Legend