I have a data sheet which has a field called location. The location field has the data like below. I wanted to use this in maps. is there a way to use the field directly or is there a way i can blend the data to use in in the maps.
PS - I'm using spreadsheet as a source.
You'll need to split the field to separate the latitude and longitude within the field into their own fields. You can assign the split fields each the appropriate geographic role. From there you can add lat/lon to rows and columns to make a map.