So I got a text file with data. Every piece of information is in it’s own line like this:
Thing1_info1 Thing1_info2 Thing1_info3 Thing1_info4 Thing1_info5 Thing2_info1 Thing2_info2 Thing2_info3 Thing2_info4 Thing2_info5
(edit above by karolus )
So my question is: is it somehow possible to by copy-paste, import or other way to tell Calc to insert (paste whatever) the info for Thing1_info1 to Thing1_info5 in a row (across five columns) and then Thing2_info1 to Thing2_info5 in another row just under it.
A large part of my data is of the format shown here so 5 pieces of data for every ‘thing’ but having a way to tell Calc ‘go to a new row’ if you encounter character like a semicolon for example would be better.
Note that I’m fairly new to Linux and LibreOffice (not that I would know how to do this in Excel - just saying).
Thanks in advance for any replies.