pull out multiple data from delimited columns

[Cartesian]

Hi all,

I'm back at it again and seeking help.
I have created a power query in excel that combines and edits multiple csv files in a folder.
The result is a table that looks like this, but has thousands of columns of data:

I would like to pull out the coordinates from the rows and dump them into columns on a different sheet in the workbook (potentially 2000 coordinate pairs).

For example, column A will pull out each "x:" coordinate , column B will pull out the corresponding "y:" coordinate from my query row 3.
Then column C will pull x: from query row 5, column D y: from query row 5
Then column E will pull x: from query row 7, column F y: from query row 7
and so on and so forth to produce something like this:

Note: there are other random text values throughout the row, so will need to look for the x: and y: to retrieve the values.
Also note, the coordinates dont always have the same number of decimal places.


I will also need to pull out other information from rows 2, 4, 6, 8 etc.
so will retrieve "info1" without the id:, or 1.5 without the line:'' etc

Thanks so much!

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1097545-pull-out-multiple-data-delimited-columns.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).