Ask Your Question
0

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:

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.

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

Comments

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
0

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

Stats

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

Seen: 61 times

Last updated: Oct 30 '16