Need help to organize various delimited cells under predetermined header row

I have an excel sheet that is generated from a report that I have to run and review every weekday. My problem is with one particular column that has a lot of data in each cell, (85-90 unique categories followed by the information, ie: “Name: Bob”, “DOB: 5/1/2020”, “Diagnosis: PTSD”, “Address: 123 Main Street, Mainville, MD”) I need each line of information broken out into individual columns so i can review the information and related trends more closely.

There are a few challenges, while some of the data is already delineated by a line break, so it’s easy to make into new columns, but some of the information is not, I have a work around for making that section of the data work correctly, but the real problem is that while there are typically has the most of the same categories of data, the information is not always in the same order, and some data is missing so when it’s delineated I can’t use a new header/top row to describe what is in each column, since they are out of order. The question is: is there a way to break a column of data into new columns, that sort themselves into the “correct” column that corresponds to the data below? I already have an idea of what order I want the data to sort in.

Sample file attached
I'm new here, please let me know if i didn't do this correctly. I'm not great with excel but i'm trying to learn more. Any help you can suggest is appreciated. And if i'm not using the right terms please let me know too. Thank you in advance!!

Key words: delimitate, organize, sort, repeat every day