I received some data where x and y coordinates are concatenated in a single cell. Extracting and connecting these together will give me either a line or a polygon.

I have provided a sample csv file below

The issue with the data I have been provided is that it has displaced field 10 onwards - but I can't tell that field 10 has been displaced unless I remove the all the concatenated geometry fields

There are 2 things that I need help with

1) extracting the x & y's so I can create geometry

2) understanding where Field 10 may have been displaced to so I can create a table that makes sense!

Any help appreciated!