Split cell with different spaces and multiple rows

[lifestorm]

Hello,

Thank you for looking at my message.

I am looking to split something as you see above and I do not have any idea how to perform it.
I tried with text to columns, but that does not help at all, neither a formula or power query I am not sure I implemented it well, but it did not work.

Could you please help with an advice in order to split the data on separate columns and rows without having a space between them?

Thank you, again!

 

[Alex Blakenburg]

How does the data from to you ? as a txt file ?
Can you open the file in Notepad and show us a screenshot of the data in Notepad and also paste the data in here.
You seem to have a different number of columns, show us how you expect the end result to look.