How to seperate Lat,Long from one column

[Anonymous]

Could anyone suggest solution. Currently I got GEO code information as below that include both Lattitude and Longitude in same column. And I would like to seperate column for Lattitude and Longtitude to plot in map. How to separate column based

GEO Code

6.803xxxx, 101.140xxxx

14.62xxxx,103.27xxxx

18.12xxxx,100.14xxxx

17.15xxxx, 99.13xxxx

[amitchandak]

@Anonymous , best is that you split that in power query/ data transformation mode

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

[lkalawski · Accepted solution]

Hi @Anonymous 

You can do this by using Split Column by Delimiter option in the Power Query Editor. 

_______________
If I helped, please accept the solution and give kudos! 😀