Display Multiple State Values in Map Visualization

[UncleNate]

Problem: Looking for input and ideas on potential solutions to display in a Map visulatizion a column in data that allows multiple entries by state.

I have attempted delimiting the State column into multiple columns, and applied those unique columns to the "Location", but only the first column is displaying in the location.

Raw Data 

ID	State
1	Alabama; Alaska
2	Alabama
3	Alabama; Arkansas
4	California; New York; Rhode Island; Wyoming

Result using this data: states display only in first value. For example, Alabama; Arkansas displays in Alabama as a unique value of "Alabama;Alaska" as a concentric circle around the Alabama value. 

Delimited Attempt 1 

ID	State
1	Alabama	Alaska
2	Alabama
3	Alabama	Arkansas
4	California	New York	Rhode Island	Wyoming

Result using this data: states display only the first state. For example, ID 1 only shows in Alabama and Alaska does not display. 

[amitchandak · Accepted solution]

@UncleNate , have you tried splitting into rows ?if that can help