Ask Your Question

DarkSocksRaily's profile - activity

2019-08-12 00:11:25 +0100 received badge  Famous Question (source)
2016-11-01 00:20:12 +0100 received badge  Notable Question (source)
2016-10-30 18:24:52 +0100 received badge  Popular Question (source)
2016-10-30 16:38:01 +0100 commented 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?

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.

2016-10-30 14:49:30 +0100 received badge  Editor (source)
2016-10-30 14:48:33 +0100 asked a 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?

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.