This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The issue here looks like the input data has an incosistent format in regards to the position of the data, so somehow you will have to try and acknowledge what values should be in what column, perhaps based on the format but that is quite a challenge.
Going on only the information provided, I don't see how you can do this without (a) manual intervention, (b) a batch macro, or (c) chained apps.
Attached is a (a) manual intervention solution.
First, you need to determine how many columns you need (based on that blank-space delimiter). Once you have that value, enter it in the other text to columns tool. This of course will result in many null columns.
Again, it's manual, but aside from creating a macro or chained app I don't see how to make it dynamic since the number of columns you need can change every time. Unless of course you know you'll never need, say, more than 100 columns.