Data Parsing from a combined data

[yashd]

Hi everyone, I am trying to work on this data but finding it as I am slowly progressing it on parsing this data.

I have uploaded the excel sheet which shows how the data is and how I am trying to do, I have this type if data over 10k :(. Would really appreciate if someone could show me a simple way to do or guide me. I am using regex but not able to parse only particular data from the combined data.

[Philip · Accepted solution]

Here's how I would approach the problem. I'd remove all the header text, then split into columns using the remaining colons.