Adjusting format while importing into calc

[sid]

I have this text in a text file which I am importing into calc.

name1 surname1      contact1 info1
name2 SR2
SR3              contact2 info2

name3 SR3     contact3 info3

I get this result

But I want second line to be like this

How can I do it quickly for large text file without manually adjusting each line.

Thank you helping the community.

[LeroyG]

@sid

in a text file

Please, edit your question, and share a reduced (and real) sample file. Thanks.

EDIT: Edit your file, just leave 5 lines (as in your example), replace real data with “xxx” or “111”, and save with a new name.

[sid]

Alas, text file cannot be shared.