Issue trying to visualize country repartition with ARCGIS MAPS

[Bastienroux]

Hello everyone,

I have a table with company names associated to 3 countries (see bellow). What I want to do is to create a map with bubbles showing the number of companies for each country.

My table looks like that :

But on the visualisation "ArcGIS Maps" I can select only one column "country". How can i transform my table in order to use the ArcGIS Maps visualisation ? 

Thank you for your help. 

Regards

Bastien

[pmay · Accepted solution]

Unpivot your data in Country 2 and Country 3.

Then your country column should look like this:

Company Name	Country
A	France
A	UK
A	Germany
B	China
B	France
B	UK
C	Germany
C	Italy
C	Japan