Split column from different words of different length and number

[aubh]

Hi guys, 

Looking for some help when trying to perform some data split. 

To make it easier to understand, I have some data scrambly mixed with string words and numbers, as shown below. 

And I would like the output looks like this: 

All string text words in one column and separate the numbers in different columns accordingly. 16 columns of digits. 

I guess I'd need the following steps: 

1. strip data between the data type, i.e.: string and numeric

2. Use data to column function, the numeric part, use space as the delimiter. 

I am currently stuck in the first step because their length is different, the number of words are different. Attached the raw data as well. Can anyone please shed some light please? Thanks. 

[DataNath · Accepted solution]

Hey @aubh,, not the prettiest but you can do this with RegEx if the pattern isn't going to deviate massively. If that's the case, let me know the potential combinations and can tweak. Workbook attached which works for your example.