Text To Excel

hi Everyone

I basically have a large text file and I want to convert into Excel exactly as I have attached both text & excel files here.
Can anyone help me how can I convert/import this 'text' file into Excel
P.S.: Please note that text file data is too large this is just sample so I can't do 'tab' settings.
any other shorter way if anyone know would be highly appriciated

Thanks
Rocky