Read clumsy data from text file

[Pandey19]

I've my sample input file attached here.

Can you someone help me in just reading this file and giving it a structure? 

[messi007]

@Pandey19,

Please see below :

I read it as csv with this space as delimiter

Attached the Workflow,

Regards,

[pdave87]

@Pandey19 Try to open the input .txt file with delimiter tab, it auto-corrects the table structure. Test run attached for reference.