parsing a pesky txt file

[CorCor]

Hello - 

I DID find some help in the community - and tried a few solutions - but none of them worked quite right.

I am sure I need to use the "text to columns" tools a couple of times....but cant work it out.

Trying to put this into a table (obvs)

Is it the file itself and not having clean delimiters?

Thanks!

[Emil_Kos · Accepted solution]

Hi @CorCor,

For me it works:

Output:

Please check my workflow maybe you have a different configuration.

If this was helpful for you please mark my post as a solution!

[CorCor]

I guess I am missing something.  Cause when I opened what you attached - I only got this.

[CorCor]

Nevermind.  It has to do with how I imported to begin with.  I get it now.

Thanks