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.