Separating text of different length in one cell into different columns

[ExcelKook]

Hi everyone,

I am trying to separate text in on cell into different columns. The issue is that the text strings are of different length (might consists of four words, two words, one word or more words). In the current file they are listed on top of each other. In the column next to them there is a numerical code that corresponds to the entries in the first column. If there are three names and three numerical codes in column one and two I would like to separate them in a way that each name and numerical code is in a separate column (this would make a total of six new columns). I have attached a sample of the data to get a better understanding (the first row shows how the data should look at the end ).

Thanks a lot for any comments!

P.s. The text to column does not work as the text string have different lengths.