Messy excel to right adaption

hello
I want to get my data in the right setting in the excels by using ‘texts to columns’. Sometimes I get the right setting (2nd picture) but sometimes I get the wrong setting (picture 1). I use the same steps in both pictures, so I don’t know what I do wrong. When I get the wrong one, I can’t even get the original (messy) data back. Is all my data gone or can I fix this?