Is it possible to tell Calc put five lines (rows) of data in five columns and then repeat the process for the next row?

[DarkSocksRaily]

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.

[karolus]

Your question here is more precisely as your crosspost in german forum

[DarkSocksRaily]

So this is like the same forum?

I didn’t know that. If it’s forbidden then I apologize. I can delete it if it’s against the rules.

[karolus]

It’s not forbidden but it’s some bad behaviour to the volunteers not placing a link between them.

see my answer there

[Lupp]

You may read the tutorial here first.