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? [closed]

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

DarkSocksRaily gravatar image

updated 2020-07-21 06:00:34 +0100

Alex Kemp 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 reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-07-21 06:00:50.595282


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

karolus gravatar imagekarolus ( 2016-10-30 16:35:01 +0100 )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 +0100 )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 +0100 )edit

1 Answer

Sort by » oldest newest most voted

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

Lupp gravatar image

You may read the tutorial here first.

edit flag offensive delete link more

Question Tools

1 follower


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

Seen: 61 times

Last updated: Oct 30 '16