Ask Your Question

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

asked 2016-10-30 14:48:33 +0200

DarkSocksRaily gravatar image

updated 2016-10-30 16:31:21 +0200

karolus gravatar image

So I got a text file with data. Every piece of information is in it's own line like this:


(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.

edit retag flag offensive close merge delete


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

karolus gravatar imagekarolus ( 2016-10-30 16:35:01 +0200 )edit

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.

DarkSocksRaily gravatar imageDarkSocksRaily ( 2016-10-30 16:38:01 +0200 )edit

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

see my answer there

karolus gravatar imagekarolus ( 2016-10-30 17:15:20 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2016-10-30 17:43:53 +0200

Lupp gravatar image

You may read the tutorial here first.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-10-30 14:48:33 +0200

Seen: 54 times

Last updated: Oct 30 '16