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?

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:

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 close merge delete

Comments

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
0

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

Stats

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

Seen: 48 times

Last updated: Oct 30 '16